Inquiry Properties window

General tab

Conditions tab


General tab

Use this tab to set general properties for the inquiry.

Field

Description

Name

The name of the inquiry

Informational text

A short description or some other information you want to appear under the title of the inquiry

Limit number of rows displayed

The maximum number of rows in an inquiry. If blank, the first 2,500 rows of data appear in the inquiry, along with a Show All button, which you can click to show all rows.

Note: In most situations, it is best to limit the amount of data in an inquiry by setting conditions. If you are producing an inquiry where you only want to see a specific number of rows without regard to which ones are excluded, then enter a number in this field.

Conditions tab

Use this tab to set conditions for the inquiry. Rows on this tab consist of three fields which you use in relation to each other.

Field

Location in row

Description

Column

Left

The column for which you want to set a condition

Condition

Middle

The operator that expresses the relationship between the column and the field on the right

Column or Value

Right

The value or column that completes the condition