Understanding the query by example (QBE) grid

The query design view is divided in two panes. The upper pane displays the tables you have selected for use in the query. The lower pane shows the query-by-example grid, in which you build the query or request.

Access Query By Example grid

The query-by-example (QBE) grid specifies the requests you are making with this query. Each column of the grid represents a field that will be used by the query. The field will be displayed in the dynaset unless you clear the Show box. You can specify a sort order and filter criteria for the field. Finally, you can create summary calculations for the field.

Many of the cells, or boxes, in the QBE grid contain drop-down lists, but those lists will only appear when you click in the cell.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.