Setting query properties
You
can right-click the background of the Query Diagram view and click Properties to:
- Prevent duplicate records.
Some queries, such as joins, can return more instances of a record
than you want to display in your layout. To make sure each record
represents a unique case--for example, one unique sale to
a customer--you can select the Unique Results check box.
- Count records.
When creating a layout, you should know how many records (data points)
will be displayed. To count the number of records returned from
a query, select the Count records check box. The COUNT() aggregate function
enables you to count the number of records for a particular field selected
in the query.
- Set maximum rows returned.
For each query, you can set a limit on the number of rows returned.
Keep in mind that if you arbitrarily limit the rows returned, your
query might not reflect the data accurately.
Note: You can set a row limit at the world level in the
World Settings dialog box. The query row limit can make the result
set smaller than the limit set for the world, but not larger. Click Tools --> World Settings and
complete the Data Control page.
