Question: how to change order of query fields in access?
Answer: Open the desired query in Design view.
Click in the Sort row of the field you want to sort by.
Click the drop-down arrow button to display the choices for the sort order (see Figure 3.6).
Select the sort order:
Click the Run button. The data appears in the designated sort order.