• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing Queries for Jet Databases > Trying the Simple Query Wizard

Trying the Simple Query Wizard

The Simple Query Wizard is aptly named; it's capable of generating only trivial select queries. If you don't have a numeric or date field in the table on which you base the query, the Wizard has only two dialogs—one to select the table(s) and fields to include and the other to name the query. Following are the characteristics of the Simple Query Wizard:

  • You can't add selection criteria or specify the sort order of the query.

  • You can't change the order of the fields in the query; fields always appear in the sequence in which you add them in the first Wizard dialog.

  • If one or more of your selected fields is numeric, the Wizard lets you produce a summary query that shows the total, average, minimum, or maximum value of the numeric field(s). You also can include a count of the number of records in the query result set.

  • If one or more of your selected fields is of the Date/Time data type, you can specify summary query grouping by date range—day, month, quarter, or year.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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