Design-view open the original query in the query grid. Right-click
each of the tables and choose "properties". Enter an alias. Change to
SQL view of the query. Select and copy all the SQL of the query.
Make a new query and view it in SQL view. Paste the SQL that was
copied from the original query. Look for the table names and
aliases... they will look like this:
FROM tblNumberOne AS Alias1, tblNumberTwo AS Alias2
Modify the table names leaving the Alias intact.
I need to take an established "delete" and "append" query, copy it, and
change the table they effect. Please let me know how I can do this without
having to recreate the query's?
Thanks,
**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security