Create a query for any values on the T1135 with Classic Database

ProFile users can create a query using Classic Database that will filter for returns with any amounts over 0 on the T1135.

The following field codes correspond to the Total boxes for each line on the T1135. Using the field codes, you can create the query using Classic Database if any of the following are true:

1. Use the navigation arrows to locate the Query tab:

2. Select the Query tab:

The Query pane displays.

3. Select the Any are true radio button:

4. Right-click in the Query pane. Select the Add option.

The Add Condition window displays.

5. Select the value is greater than in the Condition field.
6. Select the value Number and 0, respectively, in the Compare To fields:

7. Enter the individual value into the Field Name field (for example, T1135[10]).
8. Select the Add button.

The value is added to the advanced filters list:

9. Repeat the process for all necessary query values.
10. Select the OK button when finished.
11. Select the Run Query button; the query runs.