You can hide items that are displayed on the Request line. This allows you to incorporate data in the results set without displaying it. Hidden request items cannot be referenced for computations.
To hide a request item, complete one of the following actions:
Select the item and click Hide on the shortcut menu.
Select the item and choose View, then Hide Request Items.
To show a hidden request item:
Complete one of the following actions:
Click in the Request line and click Unhide on the shortcut menu.
Select View, then Unhide Request Items.
The Unhide Columns dialog box is displayed.
Select the items to view and click OK.
When you have identified the items to include in the query, you can perform a number of other operations before processing the query. You can add filters or computed items to the Request line, or you can use a Request line item to specify a sort order.
Related Topics
Using Filters
Computed Items
Applying Sorts