troubleshooting Question

Count number of records on a report then totaling number of records

Avatar of csall
csall asked on
Microsoft Access
5 Comments1 Solution287 ViewsLast Modified:
I have a report that I am creating that I want to count the number of records (permits issued to a construction company), then total them at the end of each section.  It should look like this:

Company A
    Counter 1     -    Road Permit road A
    Counter 2     -    Road Permit road C
     Counter 3     -    Road Permit road D
         Total # road permits = 3

I have the counter working by doing the following:
  * Created a Text box called "Counter" to count the records.  I set the text box as follows:
       - Set Control Source = 1
       - Set Running sum "Over Group"

Now in the detail footer I put in another text box called "Total"  to capture the total records.  I set the following on the text box:
       - Set Control Source = Sum([Counter])
       - Set Running sum "Over Group"

The problem is when I open the report I get a "Enter Perimeter Box" that asks me to define "Counter"  If I put in the number "1", everthing works fine.  How do I get rid of the "Enter Perimeter Box" when I open the report?

(Note: if I remove the "Total"  text box, I do not get the "Enter Perimeter Box" so it has to do something with the setup of the "Total" text box.)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros