Take a look at a "Totals" query, using Maximum, not Sum.
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
"Dez" wrote in message
...
I have a query set up to pull all employee weekly time records charged to
a
certain category. I want to summarize the total hours charged to that
category (which I can do), but I also want to display the date of the last
week that they charged to that category.
Any ideas as to how I can accomplish this? Any help is appreciated.