Hi, I'd really appreciate help with this Access 2003 problem:
I am trying to write an Expression in a Query that is essentially an IF function.
In plain English it would be: The field is called BuyGST and it is to calculate: If there is a Y in a field called GSTRegistered, then the answer is to be BuyCost field * 1.1, else if not true then the answer is to be 0
In Excel it would be =IF(A1="Y",B1*1.1,0)
In Access I wrote the expression as: BuyGST: IF([GSTRegistered]="Y",[BuyCost]*1.1,0)
but it tells me Undefined function 'IF' in expression