How do I query for the last date for multiple recordings in Acces.

[Guest]

I have an Access 2003 database with a table that records each time a client
would sign into their account. So there are multiple listings for each
client because it records the time stamp. How do I build my query so it
would report on only the last date stamp for each client?

Thanks

 

[Guest]

Use a group by query with max on the date

SELECT clientId, Max(MyDate) AS MaxMydate
FROM MyTable2
GROUP BY clientId