Change Table in query

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
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
update query vs make query 5
Query Does Not Pick Up Data 5
Query Does Not Count "2" Records 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
A database to calculate workhours has to invovle last monthsworkhours how? help.. 0
Recover a corrupt MDF in SQL 2K 0

Top