Recent content by david1028

That may help, I will review how the running total works. I only need a running total if the timeend and timebegin for the new department are the same. Maybe i can use Runtotal in and IIF statments...

Sorry i sent before completion Monday GGB worked 8 to 10 for ggb total worked is 2 hrs Monday FM worked 10 to 12 for wm total worked is 2 hrs, but 4 continuous I need to know how to get the continuous hours Thanks again

thank you but the issue was not getting the sum. I need to the total of continuous hours worked. Day of Week Dept Hrs Worked Total Hrs Continuous MOnday GGB 12 - 2 2

yes i have a query the calculates the time worked - ShiftHours: DateDiff("n",[starttime],[endtime])/60 and is saved in a text field Thank you again

one record for each period... i sort the records by weekending date, then by workdate and time worked. Thank you for any help

Hello, i have developed a user form for employees to enter their hours worked for each department for each day they work. They may have over 5 different work codes for each day.. work 8 - 10 for FM, then 10 to 12 for GGB and 1 to 4 for DPW. I need to track total hours for the day, which i know...

Hello all, I am excited to learn from all of you. I am new to Access but have some experience in using VBA for Excel. I am in New Hampshire, United States and like to bicycle and hike. Thank you for the invite.