percentages in queries

M

mudassir

i want to calculate percentages in queries.i have two
columns in the query each with results as 0,1,2,3.i want
to calculate the percentages of each of the results for
both the columns. it wouldnt matter if the percentages of
each column come on a seperate query
 
D

Diane Mountford

I'm not 100% sure I understand your question, but if what you want is
to figure that the number in Column A is X% of Column B, I think all
you'd have to do is make a column in your query:

Percentage: (ColA / ColB)*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

how to get the percentage symbol with the result? 3
[Project 2013] More accuracy with resource, unit %, and cost? 0
Formatting and modelling 2
Percentage Increase 11
Drop down lists in seperate columns 5
problem calculating percentages in excel for mac 2
Added zero's on a percentage field 4
Needs help combining functions. 3

Top