What is a query?
A query is a way of asking questions about data stored in computer-based tables. A query design tells a Database Management System what data to retrieve. Queries let you look at selected data from one or more tables without viewing all of the fields in each table and without having to save all of your data again. A query makes it easy to combine two or more table fields into a single field, to summarize data, to use criteria to select and sort data, and to add, update or delete large groups of records.
The only parts of a query that Microsoft Access stores are its design parameters. The data displayed in a query is called a dynaset (dynamic dataset) or a recordset. Unless you design the query to save the dynaset as a new table or part of an existing table, MS Access will not store it.