R
ramrod
HI
I am creating a DB in Access 2003.
Tables: Client - Careworker - Placement
Query: Placement query
The Placement query is link to the 3 tables and keeps records of where
the careworkers are and the no of hours they are with clients!
The careworker visit the clients the same day in each week for the
same no of hours.
Requirement: to automatically have the placement query records updated
for 14 days in advance( ie of today's date)... so data does not have
to keep being retyped !
(I have a yes/no box in Tables/palcement. called[Cover]... which I
would like to use as a clause not to update the above..(ie in advance
fill records if set to 'yes' the record is not automatically created!)
in the placement query).
Any help would be great .... Thank you ..
Ramrod
I am creating a DB in Access 2003.
Tables: Client - Careworker - Placement
Query: Placement query
The Placement query is link to the 3 tables and keeps records of where
the careworkers are and the no of hours they are with clients!
The careworker visit the clients the same day in each week for the
same no of hours.
Requirement: to automatically have the placement query records updated
for 14 days in advance( ie of today's date)... so data does not have
to keep being retyped !
(I have a yes/no box in Tables/palcement. called[Cover]... which I
would like to use as a clause not to update the above..(ie in advance
fill records if set to 'yes' the record is not automatically created!)
in the placement query).
Any help would be great .... Thank you ..
Ramrod