Counting Distinct Rows

M

Meryl

I have a report that shows the registrants to a
conference and then totals them by State (ie NJ, etc.).

In the report footer I want to print the number of States
in the report. I can't figure out how to do this. The
count function returns the total number of registrants,
not the number of distinct States.

Thanks in advance for your help.
 
A

Allen Browne

You have a group footer (or header) for State?
If not create one (Sorting'n'Grouping on View menu).

Add a text box to this section, and give it these properties:
Name txtStateCount
Control Source =1
Running Sum Over All
Visible No
Format General Number

You should now be able to add a text box to the Report footer section, and
set its Control Source to:
=[txtStateCount]
 

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

Top