Creating a query to show the most recent "many" entry

[PaulRed via AccessMonster.com]

I have a Notes table linked one-to-many with the Clients table. The Notes
table has a date field to record the date a note was made. I'm trying to
create a report that will show me just: client name & the age of the most
recent note entry. I don't know how to make a query that will select JUST
the most recent note. [This allows us to determine how recently action was
taken on a given client, without having to page through all the clients.]
Thanks for your help.
--Paul

 

[John W. Vinson]

I have a Notes table linked one-to-many with the Clients table. The Notes
table has a date field to record the date a note was made. I'm trying to
create a report that will show me just: client name & the age of the most
recent note entry. I don't know how to make a query that will select JUST
the most recent note. [This allows us to determine how recently action was
taken on a given client, without having to page through all the clients.]
Thanks for your help.
--Paul

Base it on a Query with a criterion like

=(SELECT Max([datefield]) FROM Notes AS X WHERE X.ClientID = Clients.ClientID)

on the date field.

 

[PaulRed via AccessMonster.com]

Worked like a charm! Thank you so much!
--Paul