MS Access Pivot Table Distinct Count

I have created a pivot table listing the following information
Team Members
Count of Team Member

What I need additionally is a Distinct Count of Total Team Members because some of the Team Members are on more than one team.
Who is Participating?
Dale FyeConnect With a Mentor Commented:
Good point, Pat.  I was just assuming the OP was talking about a cross-tab query.

deer77.  if you save the screenshot as a jpg or some other format, then you can click the image control (2nd from right) in the comment header and browse to that image.  You should also be able to click the "Attach File" text (bottom left corner, below the comment box) to attach the file.
Dale FyeCommented:
can you provide some sample data? and a screen shot of what you have now?
Máté FarkasConnect With a Mentor Database Developer and AdministratorCommented:
It would be more useful to attach a screenshot about design view of your pivot query.
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

deer777Author Commented:
is there a way I can drop a screenshot into this message box.  I am unable to send a file.
deer777Author Commented:
All data is in the headers of the pivot table with the individual teammember counts at the bottom of each team.  Need a distinct teammember count on the  far right column of pivot
PatHartmanConnect With a Mentor Commented:
Haven't Pivot Tables and Charts been deprecated in newer versions of Access?  I am always reluctant to use deprecated features even if they are supported by the version I am working in.
deer777Author Commented:
Can"t send a screenshot or upload a file at this time
deer777Author Commented:
Created a new team called All Team Members and got the count from that group
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.