• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 to the appropriate field(s), type in a sample criterion, and click the Run icon to view your results. Figure 4.1 shows an example of a QBE criterion that is ready to be run.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint