How to use an IF Statement in Access

[Guest]

Created a Combo Box
True add tax to the total – False don’t add tax
=IIf([Combo19]=True,[Tax]=0)
Having a lot of problems – please advice
I am open to any other solutions.
Tony

 

[Guest]

The If statement works with an IF TRUE condition and an IF FALSE condition.
So the syntax is IIf(this condition, Is True do this, Is False do this)

=IIf([Combo19]=True,[Tax]=thisvalue,[Tax]=thatvalue)

Does that clear up the problem?

Regards,
Nick.

 

[Pieter Wijnen]

If you change the logic around, you don't even need IIf as True = -1 & False
= 0
=-[Combo19]*[Tax]

Pieter

The If statement works with an IF TRUE condition and an IF FALSE
condition.
So the syntax is IIf(this condition, Is True do this, Is False do this)

=IIf([Combo19]=True,[Tax]=thisvalue,[Tax]=thatvalue)

Does that clear up the problem?

Regards,
Nick.

Created a Combo Box
True add tax to the total - False don't add tax
=IIf([Combo19]=True,[Tax]=0)
Having a lot of problems - please advice
I am open to any other solutions.
Tony