Added zero's on a percentage field

[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!!!

 

[KARL DEWEY]

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.

 

[Jeff Boyce]

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

 

[K Yero]

Now don't I just feel silly. :-(

Thanks
--
K

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.

 

[Marshall Barton]

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.

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.