I have an access database where we record hours worked for each project that we are working on (basically a timesheet database, which I have reports that will show how many hours reported to each project).
I have run into a wall. I have the total hours per person that has been worked on the project for that week, and the total hours for the week, but am unable to figure out how to get the total accumulated hours worked on the project since inception (the grand total hours spent on the project).
Is there an easy way to do this, or what am I missing?
I have a table for Straight Time and Over Time hours being reported, so those would need to be added together at the end.
(I'd attach the database, but we are pretty locked down here where I work)