Count Unique Records

  • Thread starter Thread starter Deb Struble
  • Start date Start date
D

Deb Struble

I have a query that lists a variety of information including our Dealers,
their Sales Orders, Orders Date, Gross Sales, the type of Dealer they are,
etc. I need to be able to count the number of Dealers we have sold to by
the Dealer Type. Here is an example:

Dealer Level 4
Company 1
Order #12
Order #24
Order #26
Company 2
Order #3
Order #5
Order #10
Total Level 4 Dealers = 2

I have tried using the Unique Values and Unique Records property in the
query but that didn't work. I used the Count function on the report but
that counts all the detail records rather than by Company alone. Does
anyone have any other thoughts? Thanks in advance!
Deb
 
Deb said:
I have a query that lists a variety of information including our Dealers,
their Sales Orders, Orders Date, Gross Sales, the type of Dealer they are,
etc. I need to be able to count the number of Dealers we have sold to by
the Dealer Type. Here is an example:

Dealer Level 4
Company 1
Order #12
Order #24
Order #26
Company 2
Order #3
Order #5
Order #10
Total Level 4 Dealers = 2

I have tried using the Unique Values and Unique Records property in the
query but that didn't work. I used the Count function on the report but
that counts all the detail records rather than by Company alone.
Click to expand...


The report can use a text box named txtDealerCount in the
Company group header section. Set its control source
expression to =1 and its RunningSum property to Over Group.

Then, the Level group footer can display the count in a text
box by using the expression =txtDealerCount
 
Back
Top