You can create more than one row condition to further limit the data you want to display on the report.
The following example shows how to select only rows for employees who earn a commission and whose total earnings are greater than $17,000.00. To select those rows, you need to create two row conditions: one to select only employees who earn a commission and another to select employees whose total earnings are greater than $17,000.00. Only the rows that meet both conditions appear on the report.
To create multiple row conditions:
You have created the first row condition. The row condition is displayed in the echo area, and the Specify panel displays with no choice selected.
Now you create the second row condition.
PROMPTED QUERY MODIFIED LINE 1 +-------------------------------------+ Tables: | Condition Connectors | Q.STAFF | | | Select a connector. | Columns: | | NAME | 1. Or (Either condition is true) | DEPT | 2. And (Both conditions are true) | SALARY +-------------------------------------+ COMM | F1=Help F12=Cancel | SALARY+COMM +-------------------------------------+ Row Conditions: If COMM is not NULL > ... *** END ***
You have created the second row condition. Both row conditions are displayed in the echo area, and the Specify panel displays, with no choice selected for you.
PROMPTED QUERY MODIFIED LINE 1 __________________________ Tables: | Specify | Q.STAFF | | | Select an item. | Columns: | | NAME | 1. Tables... | DEPT | 2. Columns... | JOB | 3. Row Conditions... | SALARY | 4. Sort... | COMM | 5. Duplicate Rows... | |________________________| Row Conditions: | F1=Help F12=Cancel | If COMM Is Not NULL |________________________| And SALARY+COMM Is Greater Than 17000 *** END ***
Repeat these steps to create more row conditions. You can create as many row conditions as you need to select the data you want.
[ Previous Page | Next Page | Contents | Index ]