Create a running total of job hours

[KATHY]

I have a database which includes the following info

Date Job # Hours Emp #


As the daily hours per job per emp are have been input, I need to creat a
query that will give the info in a data range (have that) but also will have
a column for Total Job Hours.

Just cant get there. I am sure this is very simple to someone?

Thanks

 

[Marshall Barton]

I have a database which includes the following info

Date Job # Hours Emp #


As the daily hours per job per emp are have been input, I need to creat a
query that will give the info in a data range (have that) but also will have
a column for Total Job Hours.

Add a calculated field to the query:

RunHours: (SELECT Sum(Hours) FROM table As X WHERE
X.[Job #] = table.[Job #] AND X.[Emp #] = .[Emp #] AND
X.[Date] <= table.[Date])