Select and Create a Query Field

Fields must be added to a query in the general order:

1. Fields that are to be used directly (as-is) from the source tables (see Fields Used Directly from Source Table for more information).
2. Table field descriptions as aliases.
3. Calculated fields.
4. Rename any fields, if desired.