Query Help

[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.

 

[Debra Farnham]

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

 

[Guest]

Thanks very much Debra, I just did it and it works like a champ.

 

[Debra Farnham]

You're very welcome

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