Help!!!!

[JustMaybe]

Hi,

GOt a real big problem holding me up!

I've got a percentage field as part of a totals calculation

e.g i have
Subtotal
Freight
Totals ( = [subtotal] +[freight])

the total is calculated by the above formulae in its control source

however i want to add calculation to include my percentage value (VAT)

but on trying the formulae

([subtotal]+[freight]+[VAT]

say the value of VAT was 5.0%
the code reads this value as 0.5 pence

rather than the value i need to read this as e.g. 5

is this a data type error?
how can i resolve this?
S

 

[Rich]

.5 is the percentage value of the total and not the amount to add, it's a math formula required

 

[Meltdown]

Like Rich says it will give you the correct calculation but if you do want to see 5.00% instead of 0.5 in the control add the following code to the "After Update" event of the VAT control

If Me!VAT.Value >= 1 Then
Me!VAT.Value = Me!VAT.Value / 100
End If