Database Reference
In-Depth Information
45
Click the Totals
button to add
the Total row to
the design grid
Criterion
(RepNum
must be 35)
Total row added
to design grid
Function
(Count)
FIGURE 2-17
Query to count records
The query results appear in Figure 2-18. Notice that Access used the default name, CountOfCustomerNum,
for the new column. You could create your own column name by preceding the field name with the desired
column name and a colon in the query design (for example, NumberOfCustomers: CustomerNum changes the
default name to “NumberOfCustomers”).
Number of
customers for
sales rep 35
FIGURE 2-18
Query results
EXAMPLE 9
What is the average balance of all customers of sales rep 35?
