Microsoft Access 2010 Bible

Part I: Access Building Blocks

142

Selecting a field in the QBE grid

Before you can move a field’s position, you must first select it. To select it, you will work with the

field selector row.

The field selector is the thin gray area at the top of each column in the QBE grid at the bottom of

the query designer. Each column represents a field. To select the Category field, move the mouse

pointer until a small selection arrow (in this case, a dark downward arrow) is visible in the selector

row and then click and drag the column. Figure 4.12 shows the selection arrow above the

Category column just before it’s selected.

FIGURE 4.12

Selecting a column in the QBE grid. The pointer changes to a downward-pointing arrow when you move
over the selection row.

Field selector

Tip
Select multiple contiguous fields by clicking the first field you want to select, and then dragging across the field
selector bars of the other fields.

Changing field order

The left-to-right order in which fields appear in the QBE grid determines the order in which they

appear in Datasheet view. You might want to move the fields in the QBE grid to achieve a new

sequence of fields in the query’s results. With the fields selected, you can move the fields on the

QBE design by simply dragging them to a new position.

Left-click on a field’s selector bar, and, while holding down the left mouse button, drag the field

into a new position in the QBE grid.