How to Sort an Access Query by Variable

Sorting your query can make it more useful.

When you create a query in Access, you can make that query more useful and more user-friendly by specifying the sort order. Changing the sort order makes it easier for users to find just the information they need, without having to have any programming ability or Access knowledge. Once the sort order is set, the data will appear in that order each time the query is run.

Instructions

1. Open Microsoft Excel and open the spreadsheet you want to work with. Click the "Open" group and select the "Query" tab.

2. Choose "Query Design" and select the table you wish to use for the query. Click "Close" when finished choosing the table.

3. Double-click the fields you want to include in the query. Click "Save" on the "Quick Access" toolbar to save the query. Give the query a descriptive name.

4. Right-click on the new query and choose "Design View." This will open the query for editing.

5. Double-click the field you want to sort. Click the "Sort" row and choose whether to sort the query in ascending order, with the smallest values on top, or descending order, with the highest values on top.

References

• Microsoft Office: Create a Query
• Microsoft Office: Sorting a Query