Share via

Query Wizard: Step 3 – Filter Records

  • Article

You can reduce the number of records by creating expressions that filter records from the selected tables or views. You can create two expressions and connect them with And, which returns only records meeting both specified criteria, or Or, which returns records meeting either criteria.

Choose Preview to see the records that will be returned based on the supplied filter criteria.

See Also

Cross-Tab Wizard | Local View Wizard | Query Wizard: Step 1 - Select Fields | Query Wizard: Step 2 - Relate Tables | Query Wizard: Step 2a - Include Records | Query Wizard: Step 4 - Sort Records | Query Wizard: Step 4a - Limit Records | Query Wizard: Step 5 - Finish | Remote View Wizard | Query Wizard