Free E-Books

Suppose, for example, you??™ve chosen ContactType, FirstName, LastName, Address, City,
138
Access Building Blocks Part I
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 check box in the Show row of each of these columns (see Figure 4-15).
FIGURE 4-15
The Show check box is unchecked for the Address and ContactType fields.
By default, every field you add to the QBE grid has its Show check box 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.


Pages:
417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441