I am young to Access and trying to build a sales report. Essentially, I have groups by state and customer with customer details plus a grand total (report footer). What I am trying to count is the number of customers within a state but due to the customer details I cannot use the number of lines to count the data. What I want to count is the sub-totals of each customer within a state to get the number of customers in the state (this for state footer). Also would like to count in the report footer the total number of customers (this for the report footer). Any help that members can provide will be most appreciated. Thanks.