As a website designer, I can say you have one of the best learning websites.”

Online Learner

Creating Opportunities For A Better Life.®

Access 2007

Single page view print copy

Using Queries to Make Data Meaningful - Part 1

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

To hide a field in your query results:

  • In the query design window, deselect the Show option by clicking on it.
    Hide Field in QueryShow/Hide Field
  • When you run your results, that field will be hidden, as seen below.

    Query Results with Hidden FieldQuery Results with Category Field Hidden
1 2 3 4 5 6 7