UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Distinct Count in subtotals    
 
   
markmcrobie
post Apr 2 2008, 08:21 AM
Post #1

UtterAccess Ruler
Posts: 1,082
From: Glasgow, Scotland, United Kingdom
Is there any way I can get a Distinct Count when using subtotals?

I 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)
Go to the top of the page
 
+
Sligo
post Apr 2 2008, 09:07 AM
Post #2

UtterAccess VIP
Posts: 972
From: Indianapolis, IN (between Terre Haute & Muncie)
You can use DCount to get this.

=DCount("ElementName","TableName","Criteria")

I hope this helps!

- Sligo
Go to the top of the page
 
+
markmcrobie
post Apr 2 2008, 09:10 AM
Post #3

UtterAccess Ruler
Posts: 1,082
From: Glasgow, Scotland, United Kingdom
What would my "ElementName", "TableName" & "Criteria" be?

And I need this to be part of the Subtotals thing.
Go to the top of the page
 
+
Sligo
post Apr 2 2008, 09:21 AM
Post #4

UtterAccess VIP
Posts: 972
From: Indianapolis, IN (between Terre Haute & Muncie)
Oops! I didn't see the Excel part.. my bad. I responded with an Access answer. I hope you'll forgive me.

- Sligo
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 03:13 PM