I need help with Dates

[AllenKarns via AccessMonster.com]

Right now I have a table which holds employee_id and Hours_Worked during any
given week. Week_Start 07/01/2007 Week_End 07/07/2007 represents wkdays 1 and
7 respectively. However, is there a way to populate a new table for reporting
purposes that gives me the actual day worked, 07/02/2007 instead of
07/01/2007 and wkday 2? Esssentially what I'm trying to do is update the
date
(in a new table) for each entry to an actual date instead of the Week_Start
and Wkday combination.

Table Name:
TimeSheetMaster

Field Names:
Week_Start
Week_End
Wkdays
Hours_Worked
Emply_ID


Thanks in Advance any help would be greatly appreacited. Very new to this.

 

[Guest]

I would use the following fields --
Field Names:
Emply_ID
Work_Day - DateTime - Actual day worked, compute week_end in a query for
rollup.
WorkCode - Default to R- Regular, then have O- Overtime, S- Sick, V-
Vacation, F- FMLA, etc.
Hours - Number - Single -- Use tenths hour (six minutes for lowest interval)

Together Emply_ID, Work_Day, and WorkCode to form unique index.