<div>
Trust Microsoft to change the name of the Function - many thanks!!
</div>


Trust Microsoft to change the name of the Function - many thanks!!

<div>
<div class="content wysiwyg-content">
Hi, I'd really appreciate help with this Access 2003 problem:<br />
<br />
I am trying to write an Expression in a Query that is essentially an IF function.<br />
<br />
In plain English it would be: &nbsp;The field is called BuyGST and it is to calculate: &nbsp;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<br />
<br />
In Excel it would be =IF(A1=&quot;Y&quot;,B1*1.1,0)<br />
<br />
In Access I wrote the expression as: BuyGST: IF([GSTRegistered]=&quot;Y&quot;,[Bu<wbr />yCost]*1.1<wbr />,0) <br />
<br />
but it tells me Undefined function 'IF' in expression<br />
<br />
Thanks
</div>
</div>


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

Thanks

IF Function in an Access Query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.