Link to home
Start Free TrialLog in
Avatar of exp vg
exp vg

asked on

Access - Design View - Crosstab - Percentages instead of Count

Please offer if there is a way for me to include in the Value in grid of query design view percentages rather than the counts.

Basically, all the values will be percentages of the total rather than counts.

Thank you.
Avatar of chaau
chaau
Flag of Australia image

You will need to use a formula Count/Total*100. Show us your existing query with some sample values and we will help you to change it to make the percentage view
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of exp vg
exp vg

ASKER

Thank you.