wgraphics
asked on
Distinct Count in Access 2002 report
Helllloooo...
For the life of me I cannot get a distinct count in an Access report.
I have numerous order ID entries and just want each to be counted only once.
Example:
1331
1331
1331
1331
----
1
1332
1332
------
1
1333
1333
1333
-----
1
And then tally up the number of unique orders (in this case , 3) at the bottom of report.
The report itself is built from a query.
I've tried every which way and cannot get it. It seems so easy!
Thanks-
For the life of me I cannot get a distinct count in an Access report.
I have numerous order ID entries and just want each to be counted only once.
Example:
1331
1331
1331
1331
----
1
1332
1332
------
1
1333
1333
1333
-----
1
And then tally up the number of unique orders (in this case , 3) at the bottom of report.
The report itself is built from a query.
I've tried every which way and cannot get it. It seems so easy!
Thanks-
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
<offtopic>
Nice to have you back, ck!
</offtopic>
Nice to have you back, ck!
</offtopic>
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Well, after a bit of adjustments on the report, I was able to get to the number I needed by using the group by OrderID suggestion offered by boag. Thank you so much for your time and patience!
great
Jeff
Jeff
ASKER
That is sort-of-what-I thought from digging around.
I am out the door- but will try the subquery later at home or tomorrow. Not exactly sure how to do that? Do I place it in the query that the report is built off of (or one of the queries that make that query?)
Thanks!