Percentage values in a crosstab query

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

Guest

I make a crosstab on some country data:

Total val1 val2
Angola 7 4 3
Ghana 11 2 9
etc.

I would like to have a percentage for each val - e.g. 4/7 = 57% for val1 for
Angola.

How is that done?
 
You could create another query based on your crosstab that calculates the
percent or just calculate these in your form or report.
 

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

How to make a VBA Function return a value in percent format 8
number types 2
How to Union Crosstabs... 1
Displaying un-matched records in query/crosstab query 2
crosstab query question. 3
WCG Stats Monday 21 August 2023 3
WCG Stats Saturday 16 September 2023 3
SQL command to GROUP BY buckets... 4

Back
Top