Running Monthly Totals
I am trying to achieve a running monthly total per job of timesheet hours logged by employees. The time sheets are logged in a timesheet entry table, where each entry relates to a job number. Then on the related job table it shows a total of the amount of hours spent by all employees on that particular job.
I want to add a field on the jobs table that shows the amount of hours spent in the current month, to see what jobs are busy etc. Just wondering what is the best way of achieving this?
Thanks in advance