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

Chapter 5. What Every Developer Needs to... > Excluding Fields from the Output

Excluding Fields from the Output

At times, you need to include a column in your query that you don't want displayed in the query output; this is often the case with columns used solely for criteria. Figure 5.28 shows an example. If this query were run, you would get the total, average, and maximum sales grouped by both country and order date. However, you want to group only by country and use the order date only for criteria. Therefore, you need to set the Total row of the query to Where, as shown in Figure 5.29. The column used in the Where has been excluded from the query result.

Figure 5.28. A query with criteria for the order date, before excluding fields from the query output.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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