G
Guest
I have a table that tracks the number of hours worked for a week. I have
several fields for Time (Worked, Vacation, Sick, School, etc) and I just need
the number of hours each employee had for each of these time fields for a
week. Our week is Sunday to Saturday. My question is how can I get the date
field to force people to use the date of the first Sunday of that work week
in my Week_of field? I would like it to make them select 1-7-07 or 1-14-07
or 1-21-07 or 1-28-07, ect. for my week of field instead of them selecting
any random date for the week.
several fields for Time (Worked, Vacation, Sick, School, etc) and I just need
the number of hours each employee had for each of these time fields for a
week. Our week is Sunday to Saturday. My question is how can I get the date
field to force people to use the date of the first Sunday of that work week
in my Week_of field? I would like it to make them select 1-7-07 or 1-14-07
or 1-21-07 or 1-28-07, ect. for my week of field instead of them selecting
any random date for the week.