Apr 2 2008, 08:21 AM
Is there any way I can get a Distinct Count when using subtotals?
have, for example, 4 rows. The company is in column A, the person's name in column B, and period ending date in C. So for a month I have 4 entries per man (one for each week). I want to use subtotals to show me a distinct count of the number of men per company. In my example above it should be 1, but using Count as it is just now shows 4 (4 x the same man)
Apr 2 2008, 09:07 AM
You can use DCount to get this.
I hope this helps!
Apr 2 2008, 09:10 AM
What would my "ElementName", "TableName" & "Criteria" be?
And I need this to be part of the Subtotals thing.
Apr 2 2008, 09:21 AM
Oops! I didn't see the Excel part.. my bad. I responded with an Access answer. I hope you'll forgive me.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here