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

  • Thread starter PaulRed via AccessMonster.com
  • Start date
P

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
 
J

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
Click to expand...

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.
 
Top