Select and Create a Query Field
Fields must be added to a query in the general order. This article describes that order.
- Fields that are to be used directly (as-is) from the source tables (see Fields Used Directly from Source Table for more information).
 - Table field descriptions as aliases.
 - Calculated fields.
 - Rename any fields, if desired.