Fields Used Directly from Source Table

Use the following steps to add fields that are to be used directly (as-is) from selected source tables to a query:

1. To add a field(s) to a query, from the Query Canvas panel, select the desired field(s) from a table. To:
• Add a single field: double-click the field, or, right-click, and, select Add to Query. The field is added to the bottom of the Field List grid.
• Add a single field, and assign the location in the list: click and drag the field to the desired location in the list.
• Add select multiple fields: press and hold the Ctrl key, as fields are selected from a table, then, right-click, and, select Add to Query. The fields are added to the bottom of the list.
• Add multiple fields in a range: select the first field in the range, press and hold the Shift key, select the last field in the range, then, right-click, and select Add to Query. The fields are added to the bottom of the list.

2. Repeat step 1 until all of the fields that are to be used directly have been selected.
3. To search for a field, type the field name or description in the Search field. Each character typed filters the search. Clear the Search field to remove the filter.