B
babs
Posted before- haven't heard back -any idea anyone?
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
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
Klatuu said: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
babs said: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