Query Calculation

[qws]

Hello,

I have a query I am using to calculate a quote to the customer. In the calculation I need to add tax to any column that I have selected through a tick box.

The formula I currently have is ([GST]*[GSTCalc])-[Cost]

This forumla works fine in itself for anything that has Tax (GST), but anything that that does not have Tax ends up being a minus figure.

I need to add something into the formula so that if there is no Tax on the product, it will only add the cost and nothing else.

Does anyone have any suggestions?

 

[PHV]

Perhaps the IIf function ?

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

 

[qws]

Hi. Thanks for replying.

My knowledge of functions such as this is almost non-existant, so not sure how I would use that in the formula.

 

[PHV]

When in VBE (Alt+F11) open the debug window (Ctrl+G) type iif and press the F1 key.

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

 

[qws]

Thanks PHV.