Saving an open select query with a new name

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

Guest

Is there a function in access 2002 and 2003 that will let me save an open
select query that was previously saved with one name with a new name?

Example: I have designed and saved a query with the name
QS_Customer_Equipment. I have opened that query and made a few changes to
its design and now I want to save it as QS_Equipment_Customer in the same
database. The end result is that I now have two saved queries in my database.

I know I can effectively do the same thing by copying the original query,
pasting it and then changing the name as part of the paste operation, but
that's a hassle.

Many thanks.

Ted
 
Hi,

You can choose File > Save As and Access will let you save the query under a
different name.

Cheers,

Andi
 
Well now that's sure embarassing! I always thought File Save As was just for
saving the whole database, and I never used it. Glad I finally asked, silly
though I now feel.

Thanks very much for your gracious reply.
 
Back
Top