Access Query Values

  • Thread starter Thread starter Almost There
  • Start date Start date
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.
 
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.
 
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?
 
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.
 
Back
Top