1*

CHOOSE QUERY
COMPONENTS

Preselect the components of
the query.

OPTION SELECTION

2*

IDENTIFY NEW QUERY

Name the query and designate public or private library.

QUERY IDENTIFICATION

3*

SELECT TABLE(S)

*Select the first or only
database table you want to search.

PRIMARY TABLE SELECTION

Select second table.

SECONDARY TABLE SELECTION

4

SELECT JOIN CRITERIA (If secondary table selected.)

Select primary key or column.

PRIMARY TABLE JOIN CRITERIA

Select secondary key or column.

SECONDARY TABLE

5

SPECIFY SEARCH CRITERIA

Specify columns to search for specific search conditions.

SELECTION CRITERIA: DESIGNATE COLUMNS

Define each search condition.

SELECTION CRITERIA: DEFINE THE CONDITION

Logically group conditions by
using AND, OR, and
parentheses.

SELECTION CRITERIA: MULTIPLE CONDITIONS

6

SET UP TEMPORARY RESULTS

Name the results columns of arithmetic expressions.

DEFINE TEMPORARY RESULTS

Select columns to include in the arithmetic expression.

SELECT COLUMNS FOR CALCULATION

Define the arithmetic
expression.

DEFINE THE ARITHMETIC EXPRESSION

7

SORT REPORT DATA

Select columns to control
sorting.

SORT CRITERIA DEFINITION

Specify order, sequence,
breaks.

ROW ORDERING

8*

DEFINE REPORT APPEARANCE AND CONTENT

Enter title, format, row count.

REPORT DEFINITION

Select data for report.

REPORT COLUMN DEFINITION

Specify column presentation
order.

PRESENTATION ORDER

Give your own titles to columns.

REPORT COLUMN HEADING DEFINITION

Select temporary result location.

FUNCTION CONTROL BREAK SELECTION

Specify a format for numeric
data.

REPORT FORMAT DEFINITION

9*

FINALIZE QUERY

*Exit GUIDE and save the
query or RETURN to previous
step.

GUIDED QUERY DISPLAY