How to Control the Display of Columns in an Access Query

An Access query allows you to pull specific information from the larger database you have created. In some cases, information is included in the query that you do not necessarily want displayed in the query results. For example, you might decide to query data for June 1, but you don't need to show the date repeating in every row in the query results. You can control whether or not a column of data appears in your query results.

• 1

  Open the query in Access. If it is not in datasheet view, switch to datasheet view using the "Field View/Datasheet View" icon.

• 2

  Using your mouse, select the column or series of adjacent columns you want to hide.

• 3

  Click on the "Format" menu on the toolbar at the top of the query window. Select the "Hide Columns" option. The columns will disappear from view.

• 4

  To show hidden columns, click on the "Format" menu again and select the "Unhide Columns" option. In the box that appears, choose some or all of the hidden columns to have them displayed again.