Current revision

Select queries (as opposed to Action Queries) are used to retrieve data from tables and other queries. Select queries do not modify the databases data in any way; they simply produce a temporary recordset of data determined by the criteria specified in the query.

Select queries usually include optional clauses to specify the criteria for records to be selected and the order in which selected records are to appear. The SELECT article describes these clauses.