Query - Sum of like values

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

 

[ACG]

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.

 

[Guest]

Sorry ment to include this:
SELECT MyTable.Date, MyTable.JobNo, Sum
(MyTable.TimeSpent) AS SumOfTimeSpent
FROM MyTable
GROUP BY MyTable.Date, MyTable.JobNo;

 

[Guest]

Thanks a bunch. It works great!

Sorry ment to include this:
SELECT MyTable.Date, MyTable.JobNo, Sum
(MyTable.TimeSpent) AS SumOfTimeSpent
FROM MyTable
GROUP BY MyTable.Date, MyTable.JobNo;