لطفا منتظر باشید ...
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.
Figure 4.30. The Total row of the OrderDate field is set to Where, excluding the field from the query result.
