Select query

Select a saved query from the list.

Range

Refine your query by specifying a set of criteria for the selected fields in the selected tables.

For more information, see Advanced filtering and query options.

Sorting

Set up sorting for your query result.

For reports, you can also set up subheadings and group totals.

If you have two or more sorting criteria, you can use the Downor Upbutton to change the sort order.

Print Options

Refine the presentation of your printed report.

Note
This tab is not included on all Inquiry forms.

Modify

Save or delete your queries.

Reset

Restore the default query.

Table

Select the table to use in the query.

Field

Select the field from the selected table to use in the query.

Criteria

Type the conditions that the field must match. You can use wildcards, such as asterisks (*).

For more information, see Advanced filtering and query options.

Search direction

Select the sorting order for the records: Ascendingor Descending.

Subheadings

Print a subheading when the value in the sort field changes.

Group totals

Print a group total when the value in the sort field changes.

Which parts of the field should subheadings be printed for?

Select the number of parts of the selected sort field to include when you group and print subheadings.

Example

Your order numbers are entered manually using the following format: YYYY-MM-DD-##### where # is a running order number.

YYYY (the four-digit year) is the first part of the order number, MM (2-digit abbreviation for the month) is the second part, and so on.

You can now sort your report according to order numbers and print a subheading each time the first part (YYYY) of the order number changes, so that you print all orders grouped by year.

You can also print a subheading each time the first two parts (YYYY-MM) of the order number change, so that you print all orders grouped by year and month.

Which parts of the field should group totals be printed for?

Select the number of parts of the selected sort field to include when you group and print group totals.

Print ranges

Include the range of the query at the top of each page of the report.

Print totals only

Print only the totals and not the individual records.

Print grand total

Print a grand total for the query result (the sum of all totals).

Remove subheaders with repetitive values

Exclude table records with repeating subheadings.

Remove group totals, if identical total

Exclude table records with repeating group totals.