Open the File menu and choose Save. If you are saving changes to an existing query, the Save process is complete; if you are saving a query for the first time, proceed to step 2.
The Save As dialog box opens. Type a name for the query in the Query Name field.
Click OK. The query is saved. When you close the query, it will be listed in the database window with the name you typed in step 2.
When you create a query using a wizard, it is saved automatically with the name you specify. If you create a query from scratch, however, you'll need to name and save it manually. In addition, you must save a query after making changes to the query's design, such as adding criteria, or adding or removing fields.
Saving the Query
If you prefer, you can click the Save button on the toolbar to open the Save As dialog box. If you try to close the query without saving first, you will be prompted to save; click Yes to save the query.