How to i use an if statement in a calculated field?

[annakalli]

Hi, I have a calculated field in my query named VAT:, this field was the multiplication of the field

AMOUNT*0.15

, but now the vat percentage is changed from the first of march to 0.17 instead of 0.15 so i want to use an if statement to check my transaction date in my query, if the date is before the 1/3/2012 the calculation to use the 0.15 otherwise to use the 0.17 .

[Mariostg]

You can use iif() function.
iif(mydate<#1/3/2012#,AMOUNT*0. 15,AMOUNT*0.17)

[NeoPa]

Indeed, or even :

=[AMOUNT]*IIf([TranDate]<#1/3/2012#,0.15,0.17)

[Mariostg]

@NeoPa.
Ok, yours is cleaner and easier to manage. :)