Most recent

[Guest]

I would like to develop a query that will give me the most recent date that a
contact has been contacted. I have a One to Many table association, that has
the date and activities associated with each contact. I would like to
determine what the date of the most recent activity is and be able to print
it in a report that lists each contact and the date of the contact.

I hope this is not too confusing.

Thanks.

 

[Ken Snell [MVP]]

Try using a subquery:

SELECT T.ContactID, T.ContactName,
(SELECT Max(Q.ContactDate)
FROM TableName AS Q
WHERE Q.ContactID= T.ContactID) AS LastContactDate
FROM TableName AS T;

 

[JohnFol]

Select ContactName, Max(ContactDate) from PeopleToContact, Contacts where
PeopleToContact.ContactID= Contacts.ContactID group by ContactName


(Sorry, can't remember the INNER JOIN syntax)