Create a running total of job hours

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

Guest

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
 
KATHY said:
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.
Click to expand...


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])
 
Back
Top