Query Help

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

Guest

I am tracking overtime hours by department. I need to create a query that
lists the department, and total overtime hours for a particular period. I did
create a query from my overtime table, but it displays each entry on a
seperate line. What I need to see is only the department name and total
hours. Like: "Parts Department 35 Hours." Thanks for your time & help.
 
Create a query based on your existing query.

In the new query only include the hours and the department fields.

Include the totals row - group by department and sum the hours.

That should do it.

HTH

Debra
 
You're very welcome :)

You'll just have to remember to alter the date criteria in the original
query
 
Back
Top