Users have the option of renaming fields in a query and the new name is not listed with the available fields.
The field name should appear as the renamed field in Query for most fields. If the original field name appears, exit and sign out (BB16633) of the program, then open Query again. The renamed fields should appear in the list of available fields. Changing the field name in the Field Characteristics section does not change the table name.