Access makes it difficult for you not to save any object you have changed, and queries are no exception.
If you close an object you have changed, Access will ask you if you want to save changes.
When you close a new query, whether from the datasheet view or the Design view, Access asks you if you want to save changes.
Occasionally you may want to use one query as a basis for another. After all, why reinvent the wheel.
It is easy to copy a query, or save the query with a new name either before or after you edit it. Here is the method I usually use to save a query as a model for another query:
- Open the original query.
- Save the query with a new name by choosing File>>Save As from the menu. I recommend saving the query now so that you do not forgetand save the new query with the old name.
Edit the query and then save it again.
You can also copy a query from the database window by selecting the query, pressing Ctrl-C to copy it and then Ctrl-V to paste it.
Rename the new query by right-clicking and choosing Rename from the shortcut menu.
Learn how to edit your query design.