Change Table in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aurora - 13 May 2008 19:20 GMT

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

Reply to this Message

Jerry Whittle - 13 May 2008 19:37 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I am using Access 2003
> A couple of years ago, I created a query to append employee files from my
[quoted text clipped - 3 lines]
>
> Aurora

Reply to this Message