While performing queries, you may want to show only some of the fields in the QBE grid. Suppose, for example, you’ve chosen ContactType, FirstName, LastName, Address, City, and State. Then you decide that you want to temporarily look at the same data, without the ContactType and Address fields. You could start a new query adding all of the fields except Address and ContactType, or you can simply “turn off” the Address and ContactType fields by unchecking the checkbox in the Show row of each of these columns (see Figure 36-15).

FIGURE 36-15
The Show checkbox is unchecked for the Address and ContactType fields.

By default, every field you add to the QBE grid has its Show checkbox selected. Another common reason to hide a field in the query is because the field is used for searching or sorting, but its value is not needed in the query. For instance, consider a query involving the invoices from the Access
Auto Auctions database. For a number of reasons, the users may want to see the invoices sorted by the order date, even though the actual order date is irrelevant for this particular purpose. Simply include the OrderDate field in the QBE grid, set the sort order for the OrderDate field, and uncheck its Show box.

Access sorts the data by the OrderDate field even though the field is not shown in the query’s results.

• Forgo the Gasoline when you Go Boating The Calypso 23e, powered by the Whisper XT Electric Outboard motor is going to debut at Fort Lauderdale's International Boat...
• U.N. Climate Chief: Next 24 Hours 'Are Absolutely Crucial' [/caption] By ALESSANDRO TORELLO and SELINA WILLIAMS - Wall Street Journal COPENHAGEN — The top United Nations climate negotiator said...
• 20th Anniversary of the Hubble Space Telescope [/caption] The Hubble telescope, launched on 24 April 1990, has had a chequered history, requiring major repairs early in its...
• Search Free Recommendations 5 Dirty, Effective Ways of Writing Ads and Sales copy There are a few basic principles that apply when it...
• SustainLane's 2008 City Ranking - How Sustainable Is Your City? I know my "city" isn't on here, as we only have a few thousand people here, but your city might...