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

Filtering Data

When selecting data with the Query Wizard, you can specify restrictions on the data that appears. If you don't specify any restrictions, the Query Wizard returns all of the records in the fields you have chosen. By setting restrictions or filtering your data, you request the Query Wizard to return only the data that you want to use for your analysis.

The Query Wizard gives you the opportunity to filter your data by letting you first select a field, and then indicate the limits you want to place on information coming from that field (see Figure 16.4). You can limit items in any field by choosing from the following options:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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