Totals for multiple report sections

I'm racking my brains over this.

I am creating a report for which I need three levels of totals - Total for
each dealer, Total for all dealers in each district, Total for all districts.

I successfully created a RecordCount text box to do a running sum count of
records by dealer, but I can't get this to work for counting all records by
district. I have a District footer, but when I try to sum all records by
district, it gives me all kinds of weird results. I tried the following
expression =Sum([RecordCount]), but when I switch to view mode, I get an
input box asking me to specify the value for RecordCount.

I also can't get the percentage of the total for each dealer and district.
Access keeps saying it doesn't recognize the names of the fields I've created
for my calculations. Help, please!

I did a =Count(*) to count all records at the bottom of the report, but I

I did group them, but for some reason, the count doesn't work when I try to
put it in the District footer.

"Michael" wrote:

Did you group all of these items? Because I believe you can do totals by
group.
"Rudolphia" wrote in message
...
I'm racking my brains over this.

I am creating a report for which I need three levels of totals - Total for
each dealer, Total for all dealers in each district, Total for all
districts.

I successfully created a RecordCount text box to do a running sum count of
records by dealer, but I can't get this to work for counting all records
by
district. I have a District footer, but when I try to sum all records by
district, it gives me all kinds of weird results. I tried the following
expression =Sum([RecordCount]), but when I switch to view mode, I get an
input box asking me to specify the value for RecordCount.

I also can't get the percentage of the total for each dealer and district.
Access keeps saying it doesn't recognize the names of the fields I've
created
for my calculations. Help, please!

I did a =Count(*) to count all records at the bottom of the report, but I

Did you group all of these items? Because I believe you can do totals by
group.
"Rudolphia" wrote in message
...
I'm racking my brains over this.

I am creating a report for which I need three levels of totals - Total for
each dealer, Total for all dealers in each district, Total for all
districts.

I successfully created a RecordCount text box to do a running sum count of
records by dealer, but I can't get this to work for counting all records
by
district. I have a District footer, but when I try to sum all records by
district, it gives me all kinds of weird results. I tried the following
expression =Sum([RecordCount]), but when I switch to view mode, I get an
input box asking me to specify the value for RecordCount.

I also can't get the percentage of the total for each dealer and district.
Access keeps saying it doesn't recognize the names of the fields I've
created
for my calculations. Help, please!

I did a =Count(*) to count all records at the bottom of the report, but I