Query - Sum of like values

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

Guest

I have a table for reporting problems. The problem and the time spent fixing
it are entered along with the date and the "job number" that the time spent
gets charged to.

I have a query that pulls all problems recorded in the past 7 days and the
time spent on each one. My problem is - I want the results to be grouped by
date and job number and the time spent totaled. Any suggestions?
 
Change the query you have (or base a new query on the
existing query) and set the 'Totals' option to 'On'. Set
the date & JobNo fields to GroupBy and the Time to Sum.
 
Sorry ment to include this:
SELECT MyTable.Date, MyTable.JobNo, Sum
(MyTable.TimeSpent) AS SumOfTimeSpent
FROM MyTable
GROUP BY MyTable.Date, MyTable.JobNo;
 
Back
Top