Costs before VAT 1

[groul]

Hello,
In a Form I got a field named "Costs". The figure I enter is the cost paid for something and includes the VAT. I want to show in a second field the costs without the VAT. Sofar no problem (for a fixed VAT figure I use "=[cost]/106*100" in case of a VAT of 6%), but the VAT might differ between 6% to 21%. The idea is to enter the end-cost-figure and then open a drop-down-list with the different VAT figures. On a click of the respective percentage-figure, the costs without VAT should appear in a field "Costs without VAT". How do I do this?
Thank you
Ulli

 

[PHV]

=100*[cost]/(100+[cboVAT])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[groul]

Hello PHV,
Thank you very much, it works just great.
Ulli