Count unique records

  • Thread starter Thread starter Jane higgs via AccessMonster.com
  • Start date 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.
 
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?
 
Back
Top