Count of unique values

[Guest]

Hi,

I have a bit of a difficult problem to count unique values of combinations
of columns in the generated table from the query. My table look in principle
like this:

Company Department Supplier Tools User
AAB HRU KKK P TAT
AAB HRU KKK T TAT
AAB HRY KKK T ESE

So I like to get different result levels in the report, like
1.) For each combination of company, dep., supplier, tools and user count
unique values;
Company Departm Supplier Tools User
AAB HRU KKK P 1
AAB HRU KKK T 1
AAB HRY KKK T 1
2.) For each combination of company, department, Supplier and user count
unique values and show by supplier;
Company Departm Supplier User
AAB HRU KKK 1
AAB HRY KKK 1
3.) For each combination company, department and user count unique values
and show by department;
Company Dep User
AAB HRU 2
AAB HRY 1
4.) For each combination of company and User count unique values and show by
company;
Company User
AAB 2

The tricky thing is to get these summary levels in the same report.
Grateful for any helpI can get!

Thanks!
Wes

2.) By department show unique combinations of all columns except Company
HRU = 2
HRY = 1

 

[Stefan Hoffmann]

hi Wes,

So I like to get different result levels in the report, like
1.) For each combination of company, dep., supplier, tools and user count
unique values;
Company Departm Supplier Tools User
AAB HRU KKK P 1
AAB HRU KKK T 1
AAB HRY KKK T 1
2.) For each combination of company, department, Supplier and user count
unique values and show by supplier;
Company Departm Supplier User
AAB HRU KKK 1
AAB HRY KKK 1

Create for each level a grouping and use DCount() with an appropriate
condition.


mfG
--> stefan <--