New table for 2007 - how to quickly update queries from 2006

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

Guest

I believe there is a way to quickly change the table that a query reads from
without having to go through and select the new table in each field all along
the 'table' line in the query. I have about 25 queries to update for 2007 -
any advice on a quick way to do this?
 
Here is a neat little find/replace utility that will help you with that:
http://www.rickworld.com/download.html

Now, let's think ahead. Wouldn't it be nice if we could structure our
queries so periodic changes are not necessary?

Now, don't even say what I know you're going to say. Instead, think
Parameter Queries!
 
Back
Top