I have two tables active. The first is a time sheet table. EmployeeName is my relationship connector for both tables and Primary Key. The Time Sheet has a date field, time in field, time out field, and a CALCULATE hours field. {Expression as: ([Time_Out]-[Time_In])*24}
The second table is a subform of my personnel form. It contains all the jobs available that the employee can work. I want to display the totals of all time sheets in the subform adjacent to the job they performed. I want this field to continuously add the hours (from the CALCULATED hours field from the time sheet table) as new time sheets are submitted to that employee.
How can this be accomplished?