Hello,

I have a data table with these columns in it one for a date, one for Job Numbers and the other for job Hours(among many other columns),

Example

Date Job Number Job Hours Blah
12/25/03......999........................8.0..............Blah
12/31/03......696.........................7.75...........Blah
12/25/03......999........................10.0..............Blah


What I want to do is group all the rows with the same date and the same job number, then add the hours. Does anybody know a way to do this?

The result of the above would be

12/25/03..............999............18.0

Oh by the way this data table is in access 2000