Share this Page URL

Chapter 6. Sorting, Filtering, and Retri... > Designing Select Queries - Pg. 215

Sorting, Filtering, and Retrieving Data 215 9. By entering a set of criteria, you can extract records that answer specific questions about your data. To do more analysis, you could summarize this set of records. You could determine how much you've spent in each expense category for all campaigns, for example, or enter addi- tional criteria to retrieve expense items for a particular campaign. In the next two sections, we'll describe how to group and summarize records in query and how to add a calculation to a query. If you're not continuing at this point, save and close qryExpenseReport.