G
Guest
I have a number of queries that are built upon certain tables.
I have now added a number of updated tables and would like to use the same
queries on them, instead.
So far I have been going into Design View, adding the new table to the grid,
then individually changing the source table in each column of the query, then
finally saving it and removing the old, redundant table.
I do not find this a particularly exciting pastime.
Is there any way of simply re-pointing a whole query at a new table in one
go, or selecting all the columns and changing the source table with one
click, (instead of about 20!).
Thanks for your help
CW
I have now added a number of updated tables and would like to use the same
queries on them, instead.
So far I have been going into Design View, adding the new table to the grid,
then individually changing the source table in each column of the query, then
finally saving it and removing the old, redundant table.
I do not find this a particularly exciting pastime.
Is there any way of simply re-pointing a whole query at a new table in one
go, or selecting all the columns and changing the source table with one
click, (instead of about 20!).
Thanks for your help
CW