Access queries come in three basic groups:
Select queries, which retrieve information from one or more tables or from other Select queries, including totals and crosstab queries
Action queries, which affect data in tables
Pass-through queries, which communicate with a SQL back-end database
This chapter covers Select and Action queries. Table 8.1 defines where you can use these queries in Access.
|Select Queries||Action Queries|
|Form record source||Macro OpenQuery action|
|Form filters||DoCmd OpenQuery in VBA|
|Report record source||Directly from the Database container|
|Source for queries|
|Data Access Pages|
|Subform source objects|
|Input to other queries|
You can ...