Percentage showing as triple digits...

[CMooreJr]

Hey all....I'm trying to figure out the following...

I have a "Cost" field that is currency
I have a "Discount" field that is percent. (Double, 0 decimal places)

When I put in say, 5 for 5 percent, it comes up as 500% What am I doing wrong? I need this to be a pecent cause I need to calculate the net cost after the percentage is taken out....

Thanks!

 

[SteveR77]

Percentage assume a muliplier of 100. So if you want 5 percent you have to enter the value as 0.05.

Steve

 

[luceze]

You can put this code in the afterupdate event of your control:

me.Discount=me.discount/100

HTH,
Eric