Thread: Date Display
View Single Post
  #2  
Old August 31st, 2007, 03:03 PM posted to microsoft.public.access.queries
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Date Display

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.