A query allows you to limit the amount of data retrieved by a report or label. For example, you could have a table containing hundreds of rows of sales data, but only require those rows that relate to a specific sales person. By using a query you can filter the table's data so that only those rows that relate to the specific sales person is used in the report or label.

 

There are two places in the application where you can create queries; the Queries item in the Project Pane, and the Record Source View of a report or label. Queries created using the Queries item can be used throughout your project file; that is, they can be referenced from within any report or label in your project. Queries created on the Record Source View of a report or label can only be used from within that specific report or label.    

 

For more information about queries, see Chapter 18: Working with Queries and Record Sources.