Count unique records

  • Thread starter Jane higgs via AccessMonster.com
  • Start date
J

Jane higgs via AccessMonster.com

I have a report that is grouped by custname. In the detail section, I will
have how many orders the customer had. I want to count how many customers
there are, but I am having trouble.

I have the custname as a header, put in a unbound textbox and put =1 and set
to running sum over group. But it does not give me the correct number.

Thanks in advance.
 
M

Marshall Barton

Jane said:
I have a report that is grouped by custname. In the detail section, I will
have how many orders the customer had. I want to count how many customers
there are, but I am having trouble.

I have the custname as a header, put in a unbound textbox and put =1 and set
to running sum over group. But it does not give me the correct number.
Click to expand...


What you said sounds like the right thing to do. What
number is it calculating and what number do you expect?
 

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

Count Unique Records 4
Count unique records Problem 6
Counting Unique Values within a Group 2
counting records 0
Count or sum unique records in a report's group footer in Access 2 2
Top N values using textbox 1
A03 - count in report footer gives me #Error? 0
Group header needs count of distinct records 3

Top