How to Display Hidden Columns in an Access 2003 Query
Queries are used to retrieve, calculate, sort, update, combine and delete fields and records in a database. They refine data in tables or other queries for analysis purposes. Microsoft Access 2003 gives you the ability to hide fields or columns in queries and tables. In queries, the hidden fields are used to perform calculations or select criteria that are not helpful if displayed in the query results. Columns are hidden or unhidden using the "Design View" or "Datasheet View" for queries and the "Datasheet View" for tables.
Other People Are Reading
Instructions
-
Design View
-
1
Open Microsoft Access 2003. Click "File" and "Open" on the menu bar. Select your database file. Click the "Open" button.
-
2
Select "Queries" from the "Options" pane. Right-click on the query that has the hidden columns. Select "Design View" from the displayed menu.
-
-
3
Check the box in the "Show" row for the hidden columns. There should be a check mark beneath every column you want displayed. Save the query.
Datasheet View
-
4
Open Microsoft Access 2003. Click "File" and "Open" on the menu bar. Select your database file. Click the "Open" button.
-
5
Select "Queries" from the "Options" pane. Open the query that has the hidden columns.
-
6
Click "Format" and "Unhide Columns" on the menu bar. Check the box next to the hidden column. Click the "Close" button. Save the query.
-
1
