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.