Change Table in query

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2003
A couple of years ago, I created a query to append employee files from my
active Db to a Retiree Db. I need to do this again and want to use the same
query. But the name of the Retiree Db has changed. How do I change the
receiving Db table name in a query that is already created?

Aurora
 
What is the SQL of the query that you are using now?

Are you talking about a Retiree Db database OR a Retiree table?

What names have been changed?

In general the best way to avoid these problems is to have a Retired Yes/No
field in the Employee table. Then base your queries on whether the Employee
is retired on not.
 
Back
Top