Counting Distinct Rows

  • Thread starter Thread starter Meryl
  • Start date Start date
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.
 
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]
 
Back
Top