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.

• In query Design view, select the Show box in the design grid to show the field, or clear the Show box to hide the field.

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.