Access 2002 Programming by Example

The Query Grid

The query grid has a table-like structure. You can select and move fields around in a grid using the same technique you used to move fields in tables. But first you must select which table(s) you want in the query. From there, you double-click or drag the fields you want down to the grid. The field order that you select is the same order that is reflected in the results. Unlike a table, you don’t see individual records, but you do have the ability to describe which fields and records you want to retrieve.

The QBE (Query By Example) design is much easier to implement than directly writing or issuing SQL code. There’s no need to write SQL code manually, because QBE creates SQL code for you. But in Design view, you simply cursor ...