Count Unique Records

[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

 

[Marshall Barton]

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.

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