Percent Discount Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me why this doesn't work?

If RetailPurchase > 0 Then
HardwareDisc= (RetailPurchase - WhlslePurchase) / RetailPurchase
End If

I have it in a button control...when the button is pushed a bunch of
calculations happen...this one keeps returning 0.00%...which is wrong:

When the Retail is $100 and Whlsle is $75 is should return 25%.

I'm sure I just have the syntax wrong but can't seem to find out how.

I have it as >0 because I only want it to return a number if Retail is
entered.

Thanks in advance,
Gee
 
should work.....obviously the equation is ok...

something dimensioned wrong? is the definition of the data in the table as
numeric?
 
Back
Top