Thank you nboth for the answers you gave, and both have got me rethinking this.
Let me explain what I am trying to do:
We have basically two schedules, Weekday and Saturday. We have various runs that the drivers do on a daily basis. Say during the week 4501A would be 7 hours, 52 minutes (7:52), but Saturday would be 6:52. What I am doing is comparing their scheduled times vs actual times. They don't alwaus do the same evry weekday.
For example, driver 1 would do 4501A Mon-Thur, driver 2 would do 4501A on Fri, 4502A on Sat, and 4503A on Tue & Wed.
raybaudi - What you suggested is great, but how would I have the second field (Scheduled Time) populate according to the assignment field? I have two tables, AssignmentsSaturday & AssignmentsWeekday.
Michael - I really like your daily layout. This would be really great to be able to use, as the drivers change what they do every few months. If I could enter a date, then choose a driver from a drop down list which would populate the Assignment & Scheduled Time according to the date would be perfect.
Tables & Fields
Table - DailyEntry
Table - AssignmentsWeekday
Table - AssignmentsSaturday
Table - Drivers
I hope this makes sense.
Thanks for you help.
Michaels example is actually what you are asking for, I have just renamed things to match your reply. You just have to create a driver table and probably pull the actual assignment hours into the scheddule table for static calulations.
TasksByDayOfWeek-v2.zip 8.8 K