Added zero's on a percentage field

  • Thread starter Thread starter K Yero
  • Start date Start date
K

K Yero

I'm trying to figure out why the percentage fields add a couple zeros to the
query and report numbers that I insert in a table. As an example, if I put
in 25 and the number and I tell the query or report that I want it to display
the number as a percentage it will show up on the report as 2500%. No
decimals becuase I have that set to 0. I don't understand why Access is doing
that.
Anyone come across that before? What can I do? I'm trying to use that number
in a calculation and if the calculation reads it as 2500 instead of 25
percent, my sales projections will be waaaaaay off base.

Help!!!
 
Yep, lots of folks make the same mistake.

A percentage is a decimal fraction of a whole. It happen mathmatically
that 50% of something is half and is expressed as 0.5 which is half of one.

When you enter 25 to be displayed as a persentage Access multiplies it by
100 and adds the percent symbol just like you asked it to do.

If you want 25% display, which just happens to be a quarter then you have to
enter 0.25 for it to display correctly.
 
Uhm...

25 IS 2500%.

If you need 25%, you need to start with .25 (recall, 25/100 = .25 = 25%)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Now don't I just feel silly. :-(

Thanks
--
K


KARL DEWEY said:
Yep, lots of folks make the same mistake.

A percentage is a decimal fraction of a whole. It happen mathmatically
that 50% of something is half and is expressed as 0.5 which is half of one.

When you enter 25 to be displayed as a persentage Access multiplies it by
100 and adds the percent symbol just like you asked it to do.

If you want 25% display, which just happens to be a quarter then you have to
enter 0.25 for it to display correctly.
Click to expand...
 
K said:
I'm trying to figure out why the percentage fields add a couple zeros to the
query and report numbers that I insert in a table. As an example, if I put
in 25 and the number and I tell the query or report that I want it to display
the number as a percentage it will show up on the report as 2500%. No
decimals becuase I have that set to 0. I don't understand why Access is doing
that.
Anyone come across that before? What can I do? I'm trying to use that number
in a calculation and if the calculation reads it as 2500 instead of 25
percent, my sales projections will be waaaaaay off base.
Click to expand...


If you are using whole numbers, then that is the correct
percentage. OTOH, 25% is the number .25.

You need to either divide your number by 100 or don't use
the percent format.
 
Back
Top