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.