Hi!
I've been trying to work on a database for a company that wants to keep track of Hours worked by the employees... without purchasing something like MYOB.
I have nearly completed the database, and as i was completing the final step, The reports. I wanted to add something that would calculate the hours for the record.. and then proceed to another record. and then at the end add up all the hours into a final sum that the employee had worked for the week.
I have worked out the way to add up for the one record. but how do you add it over multiple records.. If this makes sense?
I have attached a screen shot that might give more of an idea if it doesn't give a clear idea..
Thanks heaps!!!!
Brad