filter last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database that keeps a record of all calls made for each client.
what i want to do is to be able to print a report for all active clients
which would let me know when they were last contacted.

i have a query which limits the clients to active clients but it gives all
calls for each client. i only wnant to know when the last call was. can you
please help

thanks richard
 
You can try something like

Select * From TableName Where DateLastContacted = DMax("DateLastContacted",
"TableName","[Client] = " & [Client])

If the client is text field then change it to
Select * From TableName Where DateLastContacted = DMax("DateLastContacted",
"TableName","[Client] = '" & [Client] & "'")
 
Back
Top