Date problem

[bigfoot53]

Hello All,

i have a DB that i made for work that tracks employee time both regular and overtime. the main form works fine and contains the following data : supervisor name : employee name: employee ID : job name: job ID: shift: regular hours: overtime hours: and Date . all are stored in a table called "work"
i then created a sub form that i need to Based on the employee ID: form the main form display the total hours both regular and overtime. fot the current week Sunday to Sunday.

thanks for any help.
Bruce

 

[llkhoutx]

Criteria for the subform should be Employee ID, Sunday's Date, and Sunday's Date plus 6 days.

this potentially requires a record for each date for each employee. What not have a record for each week?

 

[bigfoot53]

Yes a record for each dat is created. here is the DB
I also need to display in the subform total hours so far this week .

thanks

 

[llkhoutx]

Your zip file wouldn't download for me.

 

[bigfoot53]

i just tested it form home and it downloads fine for me not sure why you can,t try again.

 

[Rich]

Your table structure is incorrect, if one employee can have many dates recorded then those records belong in a separate table with a one to many relationship with employee, in fact you could also argue that one supervisor can have many employees, and one employee can have many jobs, search here for posts on normalise or normalize and read some of the many posts by Pat Hartman on the subject