Reuse a query but need to change tables

[is800025]

How do I update the names of the tables within an existing query? I tried to change by changing the names, but Access doesn't recognize them even though I have added the new tables and deleted the old ones.

Thank you.

 

[Joe4]

Welcome to the Board!

The way I usually do something like this is change your query to SQL View, and copy and paste the code out to something like Word, NotePad, or WordPad. Then do a simple Find & Replace, replacing the name of your old tables with the names of the new ones. Then copy & paste that code back into a query in SQL View, and you are good to go!

 

[is800025]

Thank you.