2012

To construct a query with multiple parameters on the Query Builder tab
1 Enter the first parameter of your query as described above.
2 Select the appropriate And or Or operator from the Logical field.
Clicking in the Logical field inserts an And operator. Clicking the cell
again changes the value to Or.
3 Enter additional query parameters on subsequent rows of the Query grid.
4 Repeat step 2 for each additional parameter except the final query
parameter.
5 Apply any parenthetical grouping, if appropriate. Click the cell to the
left of the Field cell that begins the phrase that you want to group. A
single left parenthesis is inserted. Click the cell to the right of the Value
cell that ends the phrase that you want to group. A single right parenthesis
is inserted.
6 If you want to save the query in the current drawing for future use, click
Store.
7 Click Execute to execute the query and close the dialog box.
To specify what fields appear in your returned query
1 Construct your query as described above.
2 Select the first field that you want to appear in the Fields in Table list.
3 Above the Show Fields list, click Add.
4 Repeat steps 2 and 3 for any additional fields you want to display.
To specify a sort order for your returned query
1 Construct your query as described above.
2 Select the first field that you want to sort on from the Show Fields list.
3 Above the Sort By list, click Add.
By default, the selected field is sorted in ascending order. Click the Sort
button to sort in descending order.
4 Repeat steps 2 and 3 for any additional fields that you want to sort on.
Use the Query Builder | 2039