Microsoft Access 2010 Bible

Chapter 4: Selecting Data with Queries

139

FIGURE 4.8

Adding fields in the QBE grid. Clicking the down arrow in the field box reveals a drop-down list from
which you select a field.

Table Upper pane

Query by Example grid

Adding multiple fields

You can add multiple fields in a single action by selecting the fields from the Field List window

and dragging them to the QBE grid. The selected fields don’t have to be contiguous (one after the

other). Hold down the Ctrl key while selecting multiple fields. Figure 4.9 illustrates the process of

adding multiple fields.

FIGURE 4.9

Selecting multiple fields to add to the QBE grid