In Access query design is essential for getting the data you want. Use query design in Access to design almost any query you want.
Sometimes you might have fields that contain important criteria, but you might not need to actually see the information from that field in the final results. For example, take one of the queries we built in our last lesson: a query to find the names and contact information of customers who had placed orders. We included Order ID numbers in our query because we wanted to make sure we only pulled customers who had placed orders.
However, we really didn't need to see this information in our final query results. In fact, if we were just looking for customer names and addresses, seeing the order number mixed in there might have been distracting. Fortunately, Access makes it easy to hide fields while still including any criteria they contain.
To unhide a hidden field, simply return to Design view and click the checkbox in the field's Show: row again.