Miscellaneous Tab, Query and View Designers

  • Article

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.

Top

Selects a quantity or percentage of records from the result set. When specifying a number or percentage, use the Order By Tab, Query and View Designers 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.

See Also

Fields Tab, Query and View Designers | Filter Tab, Query and View Designers | Group By Tab, Query and View Designers | Order By Tab, Query and View Designers | View Designer