Access Query Values

A

Almost There

I generate the numeric values that I want in a cross tab query but cannot get
it to change the values to percentages in relationship to totals in that
view. The percent format just makes the numbers larger but not the right
place value. Please help.
 
K

KARL DEWEY

You do realize the 25% is actually a fraction and the number is 0.25 rather
than 25 do you not?
Are you trying to format a whole number as a percent and it is multiplying
it by 100? That is normal.
 
A

Almost There

Karl yes I know that but I should be able to convert all those values to
percentages by dividing the single row values by the grand totals across or
vertically right?
 
K

KARL DEWEY

Are you talking about adding percentages? No you can not.
Only if they all are a subset of the same set.

Maybe if you posted example of your data and what you are trying to do then
someone might be able to suggest a method.
Post any calculated fields or the SQL of queries you have tried.
 

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

Control Select Query Output Field Type 8
Crosstab query alters numeric values 3
Blank or Null in a Cross Tab Query in Access 2003 2
Adding my own rows to a Union Query without adding another table? 3
IFF in Query?? 3
Changing commission rate at a future date 5
Cross Tab Query with two values 1
Percent total 101%! 1

Top