T
T & M Wilson
Hi
I'm trying to use the results of a Select Query as the "Update To"
parameters of an Update Query.
I have selected specific records from one table with a "Select Query"
that I now need to update to certain fields in a second table as
follows;
A weekly scheduling system that uses a template appended to master
schedule table then updates the just appended schedules to the
appropriate week number. I'm trying to introduce sub rotations to the
system and have written the query to extract this data. i.e. If the
rotation starts on week one, it's a five week rotation, and I'm
appending week six the query returns week one of that rotation. So far
so good. I now need to update the specific employees with that
rotation. (number of rotations can vary - number of weeks in a rotation
can vary - number of employees in a rotation can vary - starting week
can vary from rotation to rotation)
With my test data I currently have a 2, 3, and 5 week rotation with 4,
3, and 2 employees respectively and the query returns the correct 9
records.
The problem is the "Update Query" will preview the records to update but
not run the update. How to I refer to a query as the update parameter
for multiple fields?
Any thoughts would be greatly appreciated.
Access97
taw
I'm trying to use the results of a Select Query as the "Update To"
parameters of an Update Query.
I have selected specific records from one table with a "Select Query"
that I now need to update to certain fields in a second table as
follows;
A weekly scheduling system that uses a template appended to master
schedule table then updates the just appended schedules to the
appropriate week number. I'm trying to introduce sub rotations to the
system and have written the query to extract this data. i.e. If the
rotation starts on week one, it's a five week rotation, and I'm
appending week six the query returns week one of that rotation. So far
so good. I now need to update the specific employees with that
rotation. (number of rotations can vary - number of weeks in a rotation
can vary - number of employees in a rotation can vary - starting week
can vary from rotation to rotation)
With my test data I currently have a 2, 3, and 5 week rotation with 4,
3, and 2 employees respectively and the query returns the correct 9
records.
The problem is the "Update Query" will preview the records to update but
not run the update. How to I refer to a query as the update parameter
for multiple fields?
Any thoughts would be greatly appreciated.
Access97
taw