Month Totals

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

Guest

I have a query that has the names of employees and the dates and hrs. they
did a job, about 10,000 entries from Jan to present. How do I make a query
total the time by month for each employee?

Thanks!!
 
Hi,

I havet tested this, but something like

Select "Employee Field"
, Month("Month Field")
, Sum(Hours)
From YourTable
Group By Month("Month Field");

HTH

Simon
 
Back
Top