percentages in queries

  • Thread starter Thread starter mudassir
  • Start date Start date
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
 
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
 
Back
Top