SELECT QUERY (?)

[PEASLET]

Hi - can anyone help with this?
I need to select company details from one table where a certain condition on the most recent record of another table is met. At the moment, it's bringing up all the records of table 2. I expect there's a simple statement to do this but I can't think of it. I would be most grateful for any help with this

 

[THoey]

It would help if you posted your current query. The we can tune it to meet your needs... Terry M. Hoey

 

[PEASLET]

SELECT DISTINCTROW [Client Details2].ContactsID, [Client Details2].CompanyName, [Contact Log].FirstName, [Contact Log].LastName, [Follow-up Log].[Places booked], [Follow-up Log].Date
FROM (([Client Details2] INNER JOIN Checklist ON [Client Details2].ContactsID = Checklist.ContactsID) INNER JOIN [Contact Log] ON [Client Details2].ContactsID = [Contact Log].ContactsID) INNER JOIN [Follow-up Log] ON [Client Details2].ContactsID = [Follow-up Log].ContactsID
WHERE ((([Follow-up Log].Details) Like "*CIS*") AND (([Contact Log].[Reason for Contact]) Like "CIS"))
ORDER BY [Follow-up Log].[Places booked] DESC;

It's companies booking on courses and some have booked on more than one course. The details of the courses they have booked on are in the 'Follow-up Log'. I can identify bookings for the current promotion 'CIS' because
[Contact Log].[Reason for Contact]has the entry CIS. I only want the info if it is for the CIS course. I thought I would be able to get just this info by getting the most recent follow up logs as they're all for the CIS course

I'm sorry if this sounds garbled, I'm in a hurry. If you can't understand what I'm on about, I'll try & clarify it later. I really do need the answer though!!