Copy a query in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Open the query in SQL view, copy it.
Create new query and when the table selection box appears click cancel. Now
paste the old SQL into the new query.
Finally, substitute the old table names for the new ones.

Lee
 
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,
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Back
Top