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

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

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
 
Use a group by query with max on the date

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