Counts

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi I have a report which lists surnames and which runs to about 20 pages. Is
there anyway to put a count at the end of the report to count the number of
surnames, or better still place an incrementing number to the left of each
surname.


Thanks

Alex
 
For a counter beside each name, open your report in design view, and add a
text box with these properties:
Control Source =1
Running Sum Over All

If you want just the total count at the end, add a Report Footer section
(View menu), and in that section add a text box with these properties:
Control Source =Count("*")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
counting records 0
Report 2
Table of Contents 2
A03 - count in report footer gives me #Error? 0
"duplicates" of primary sort are deleted! 6
Multiple Count Ifs 3
Setting text in bold 3

Back
Top