MainForm(weekly) detail of week sched. in Subform

[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

 

[Klatuu]

When you say "without having to filter", it males mp sense. To get only the
days for a week beginning on Sunday, you do have to filter, but not at the
form level.

Use a query as the form's Record Source with:

WHERE [WorkDate] BETWEEN Forms!MainForm!StartDate AND DateAdd("d", 6,
Forms!MainForm!StartDate)

 

[babs]

I have the one Table with the Employees as the One side (Main Form) linked
to the subform Many side with the soc. sec.# and what they are scheduled for
on the TimeCard Table (see below) the date they are scheduled for is listed
in this table -

Not clear how to put the Start Date field on the Main form if not on that
table.

Do I make a query with all fields from employee table and add the date field
here??

Not clear on in the actual query how to set up the WHERe code - am I
prompting the user for EACH record (0n Main what they are schedule for for
that given week????

Just really want EACH record (main) to be a give start of the week( all jobs
schedule for That week have the SAME Start of the week date - ex. all say
8/9/09 for that week

Want to see each employee for that given week as one RECORD - and subform
would show spec. jobs worked that week.

Next record can be another employee for that week , or another week for that
same employee

ie. each main record is an employee and their scheduled/actual work for a
given week.(

thanks for your help,
Barb

When you say "without having to filter", it males mp sense. To get only the
days for a week beginning on Sunday, you do have to filter, but not at the
form level.

Use a query as the form's Record Source with:

WHERE [WorkDate] BETWEEN Forms!MainForm!StartDate AND DateAdd("d", 6,
Forms!MainForm!StartDate)
--
Dave Hargis, Microsoft Access MVP

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