Calculated fields in forms

[nicwnacw]

Help! I have no VB or SQL skills - just Access and simple macros, I have to design a database that does sales/purchaes and stock control. I can do most of this with macros and queries. However the client has some customers which are exempt from paying VAT and some which aren't. I have a calculated field

=Iif([VAT Exempt]=-1"17.5%","0%")

this returns the correct rate of VAT but I can't get the next stage to work i.e. subtotal (from quantity* price) * VAT

can anyone help please - the sales order form is based on customers with 2 subforms - transaction and stock

 

[Rich]

Your calculation needs to return a number, not a percentage or a string
Iif([VAT Exempt],.175,0)

 

[nicwnacw]

calculated fields

Thank you sooooo much - not very good at sums either I should have been able to do that