changing tables in query question

[baseball]

Access 2007/Win 7: I have a database with large tables covering different time frames. Sometimes I develop a query using Query Design for one period, then need to run the same query with another time period. I go to Edit Query/Show Tables and pick the new one, then I have to go to each field and change the table source. Is there some way change all the fields at once?

 

[james_lankford]

view the query as sql

copy the sql to notepad

find where it ways

from mytable

change it to
from mytable as t

then do a search and replace

replace all
mytable.
with
t.

now copy the sql and put it back into access

it should run fine, and from now on anytime you want to change the table you only have to change one thing

change
from mytable as t
to
from mytable_2010 as t
then next time
change it to
from mytable_2011 as t

 

[baseball]

I thought of that way of doing things but I was hoping there was some easy way. Most everything in Windows lets you select a number of things and apply something to all at once. I sometimes think Access is not a Microsoft product.