B
babs
I have an employee table - listing each employee one time (soc. sec #) PK,
Man Name, address, Position, etc.
Then I would like for ONE Given WEEK (Date field- Just shows the Scheduled
date at the Sunday for that Given Week)- example 8/9/09(not sure where this
goes)
- to show what that employee is schedule for That 8/9/09 week ONLY for one
visible record on the main form
I have a TimeCard Table that show the Date Sheduled(8/9/09) at well as the
Job#, Job Name, Number of hours Mon, Tue, Wed, thur etc. sheduled
When I make the form with the employee on the main for ALL jobs for All
dates that the employee is sheduled for show up. - really only want to see
the ones for a Given Week- all would say 8-9-09 since they are sheduled on
the Sunday.
not sure how I can Just show this weeks Jobs automatically with having to
filter???
What am I missing????
Thanks,
Barb
Man Name, address, Position, etc.
Then I would like for ONE Given WEEK (Date field- Just shows the Scheduled
date at the Sunday for that Given Week)- example 8/9/09(not sure where this
goes)
- to show what that employee is schedule for That 8/9/09 week ONLY for one
visible record on the main form
I have a TimeCard Table that show the Date Sheduled(8/9/09) at well as the
Job#, Job Name, Number of hours Mon, Tue, Wed, thur etc. sheduled
When I make the form with the employee on the main for ALL jobs for All
dates that the employee is sheduled for show up. - really only want to see
the ones for a Given Week- all would say 8-9-09 since they are sheduled on
the Sunday.
not sure how I can Just show this weeks Jobs automatically with having to
filter???
What am I missing????
Thanks,
Barb