Percentage

[Guest]

I have wrote a programme and need to remove discount from customers parts
that they have every time i enter the percentage they get it changes it ie:
10 goes to 1000 and 1 goes to 100.
Please help

 

[JK]

Vicky,

Access keeps the real number and only "Mask" it with a percentage sign
You need to enter 0.1 for 10% 0.25 for 25% etc.

If you want the user to enter the actual percent number (25=25%) you can do
it in the After Update event

Private Sub Discount_AfterUpDate()

Me.Discount=Nz(Me.Discount/100,0)

End Sub

Regards/JK

 

[Joseph Meehan]

I have wrote a programme and need to remove discount from customers
parts that they have every time i enter the percentage they get it
changes it ie: 10 goes to 1000 and 1 goes to 100.
Please help

We are going to need more information. What are the field types? Is
the "programme" written in VBA or what? Where is the it used? etc.