Lesson 33: Creating Complex Queries. Lesson Objectives. After studying this lesson, you will be able to: Create a select query involving multiple tables Create a report based on multiple tables in a query Create and run parameter queries Create a calculated field in a query
Criteria expression prompts user for a value when the query is run
Criteria expression appears in the query grid Criteria row
Tip! Brackets always surround the criteria expression.
Action query types
Source table is the active table; destination table identified in the dialog box