Combine values?

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

Select Sum(Job) from table where datefield = 'thedate'

Sorry to bug you again!:)


Is there any way to do this by looking for two values?

Like date and employee name ?

Something kinda like this?????

select sum(job) form table where datefield = ' thedate' and form table where namefield = ' thename'

Anyway to do this?