Counts

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
 
A

Allen Browne

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
Report 2
Table of Contents 2
counting records 0
ONE of us can't count. 2
Using Unique Values and Unique Records 13
VLOOKUP with more than one possible response 2
Unbound text 4

Top