Using Queries to Make Data Meaningful - Part 1
In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.
Hiding fields or other information in the results
Sometimes the results of a query will include information that is seemingly unnecessary to you. Access 2007 allows you to easily hide these fields.
To hide part of the query result:
- In the query design window, deselect the Show option by clicking it.
- When you run your results, the field you chose will be hidden, as seen below.
Query Results with Category Field Hidden