How to Hide, Remove, and Sort Fields in Access
There are many ways that you can work with your fields in a query. You can hide fields from appearing in a query's results, change how they will appear, or remove them altogether.
To see how these things work, first create a query to work with.
You can also open a query in Design view by right-clicking the query object in the Navigation Pane and selecting Design View. Or, click the Design View button in the Status bar.
Now add the fields that you want to use in the query.
You can add every field from a table in a query by adding the asterisk (*) symbol at the top of a field list.
You can hide a field if you want it to be in a query but don't want it to be displayed in the query's results.
The field will no longer appear in the query's results.
You can easily remove a field from a query if you no longer need them.
The field is removed from your query.
Tables normally display records in the order they were entered. Instead of working with a table's jumbled record order, you can create a simple query that sorts the table information and presents it in an ordered, easy-to-read display.
If you want to use a field to sort the table, but you don't want that field to appear, you can deselect its Show box.
Access displays the results of the query.