Crosstab Query Wizard...Can percentages also be displayed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the Crosstab Query Wizard to count values, is it possible for
either the Query or Report (made from the query) to also display the
percentages that sum to the total column? Here's an example of what I'm
looking for:

TOTAL CATEGORY1 CATEGORY2
4 (100%) 3(75%) 1(25%)
 
Yes. Edit the source of the value. If the currect source is Quality and
the Total is the Sum([Quality]) then use this in the grid --
[Quality] & " ( " & [Quanity]/Sum([Quanity])*100 & " )"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query help 1
Report Using Crosstab Query Causes Errors 3
How to multiply percentages in a CROSSTAB-action 1
MS Access Query Design Question 0
Distinct Count in Crosstab 1
problem with crosstab query 1
CrossTab Error if data not present 1
Mysterious Parameter Added?? 8

Back
Top