Percentages Help

S

Stephen Lynch

I have set a few fields Percentage1, Percentage 2 and so on as TYPE single.

when I enter the as such

Percentage1 .25
Percentage2 .28

It adds up to 0.529999971389771. What gives here?

I need it to be precise for error checking that I am doing it there a
different way to code the percent type?
 
R

Rick Brandt

Stephen said:
I have set a few fields Percentage1, Percentage 2 and so on as TYPE
single.
when I enter the as such

Percentage1 .25
Percentage2 .28

It adds up to 0.529999971389771. What gives here?

I need it to be precise for error checking that I am doing it there a
different way to code the percent type?
Click to expand...

Single and Double are not precise types. If you need that use Decimal or
Currency.
 
J

Jim Burke in Novi

If you want more precision you should use double, not single. See if that
takes care of it. But occasionally a number will end up being off by some
small fraction.
 
Top