MS Access Pivot Table Distinct Count

I have created a pivot table listing the following information
Team
Team Members
Role
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.
deer777Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
can you provide some sample data? and a screen shot of what you have now?
0
Máté FarkasDatabase Developer and AdministratorCommented:
It would be more useful to attach a screenshot about design view of your pivot query.
0
deer777Author Commented:
is there a way I can drop a screenshot into this message box.  I am unable to send a file.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

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
0
PatHartmanCommented:
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.
0
Dale FyeOwner, Developing Solutions LLCCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
deer777Author Commented:
Can"t send a screenshot or upload a file at this time
0
deer777Author Commented:
Created a new team called All Team Members and got the count from that group
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Pivot Tables

From novice to tech pro — start learning today.