Specifies other record selection conditions for the query or view.
No Duplicates
Eliminates duplicate records from the query or view results. Duplicate records are records in which every field matches.
Cross-Tabulate(Queries only)
Sends the results of the query or view to Microsoft Graph, a report, or a table in cross-tabular format.
The Cross-Tabulate option is enabled only when Selected Output contains exactly three items. These three items represent the X axis, the Y axis, and the cell value for the graph.
Note This option automatically selects the Group and Order By fields for the query. Once selected, you can no longer modify the query unless you clear this option.
For example, you could generate a report that shows the amount billed to clients by month. You would create a graph that displays clients down the left side of the page, the twelve months across the top of the page, and, within the graph, the amount billed to each client each month.
Selects a quantity or percentage of records from the result set. When specifying a number or percentage, use the Order By tab in the Query and View Designer to choose which records are at the top of the result set.
All
Specifies that all of the records selected by the query or view should be included in the results set.
Number of Records
Sets a quantity of records of the selected records to include in the results set.
Percent
Changes the number in the box above to a percentage of records.