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

How do I freeze the swimlane headers? 0
Control Select Query Output Field Type 8
How to display zero value in blank fields of Cross Tab query 0
Creating a Chart on form from selected data in query. 0
Word macro that can call cells out of Excel for a find and replace 0
Calculate the median value before a specified list 0
Any way to know the PRECISE indent values? 3
Blank or Null in a Cross Tab Query in Access 2003 2

Top