Show or hide a field in a query's results

You can add to the query design grid a field that you use for setting criteria or a sort order, yet not show the data from that particular field in the query's results.

1. Open the query in Design view.
2. In the design grid, do one of the following:

   To show the field, select the Show check box.

   To hide the field, clear the Show check box.

Notes  

• If you want to create a form, report, or data access page based on the query, and the query's OutputAllFields property is set to No, you must show the fields for which you will create bound controls on the form, report, or data access page.
• When you close a query, Microsoft Access moves hidden fields to the rightmost columns in the design grid.