Publication Date: 8/17/2026 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

Select Distinct

The Select option allows users to select specific information to query (i.e. A/C flight dates from January 1, 2006 to January 31, 2006).

Creation_2

Open a table and enter the formulas under the Column, Operator, Value, and Logical field to select the flight dates of A/C 300 from January 1, 2006 to January 31, 2006, as shown below. Select the Distinct checkbox.

Distinct_1

 

The following information/options are available in this window:
_____________________________________________________________________________________

Column

Select a column for the clause.

Note: The columns used in the clauses are from the selected tables but not necessarily in the print.

Operator

Select an operator for the clause.

Value

Select a value for the clause.

Note: All values must be in parenthesis. Right-click in field for a list of possible values.

Logical

Select a logical connector to the proceeding clause.

_____________________________________________________________________________________

Preview the report. The query has been limited to flight dates between January 1, 2006 to January 31, 2006 for the A/C 300.

Distinct_2

See Also

Additional Quick Print Options

Print Orientation

Preview Options

Title of Print

Updating Changes

Saving and Deleting the Quick Print

Sort/Filter Quick Print Data

Fixed Assets Registry Audit

Security Options On The System

Top of Page Publication Date: 8/17/2026 Share Print