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

Chapter 4. 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 4.29 shows an example. If you run this query, you get the total, average, count, and maximum sales grouped by both country and order date. However, you want to group only by country and use the order date only as criteria. Therefore, you need to set the Total row of the query to Where, as shown in Figure 4.30. The column used in the Where has been excluded from the query result. You can easily determine this by noting that the check box in the Show row of the OrderDate column is unchecked.

Figure 4.29. 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