They can be chained together (one query uses another query), and are used throughout MS Access forms and reports. Most users are familiar with queries that generate results: select queries, select queries with totals, and crosstabs (which Excel users appreciate the most).
By default, Access Select queries are updateable (editable).
A Microsoft Access Update Query updates specified values in a table for all records or for those records that match a specified criteria. Close Set rs = Nothing Set qdf = Nothing Set db = Nothing End If End Sub The results from the Immediate Window appear as follows. They allow you to perform a wide variety of very powerful analysis and actions.The following demonstrates how to open a query as the recordsource and loop through it and print the data to the immediate window. In this case, a table with salespeople and their sales figures will be used. Next, construct code in a VBA Module to generate the recordset with DAO objects and loop through it. You have decided that you will use an Update Query to change all of the relevant records in your Products table.