Access vs. Excel If Statements

[nancybrown]

Will Excel IF statements work in Access queries?

Thank you.

 

[alansidman]

The syntax is the same, the function is immediate if shown as =iif.

http://www.techonthenet.com/access/functions/advanced/iif.php

Look at this link

 

[nancybrown]

Or would this work?

iif([2008 payment terms]=([2009 payment terms],"Updated","No Change")

 

[SydneyGeek]

Too many parentheses... try

iif([2008 payment terms]=[2009 payment terms],"Updated","No Change")

Denis

 

[Fazza]

Are the results are mixed up?

'so instead of
iif([2008 payment terms]=[2009 payment terms],"Updated","No Change")
 
'maybe
iif([2008 payment terms]=[2009 payment terms],"No Change","Updated")

 

[james_lankford]

ah, Fazza beat me to it