select query

A query that asks a question about the data stored in your tables and returns a Recordset or rdoResultset object without changing the data. Once the Recordset or rdoResultset data is retrieved, you can examine and make changes to the data in the underlying tables. In contrast, action queries can make changes to your data, but they don't return data records.