IIF with "OR" And "And"

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to apply same below excel formula in Access, but I am not able to apply in access. I know that in Access formula is IIF but I don’t know how apply “OR” And “And” together
<o> </o>
=IF(OR(J2<=0,AND(F2<>"<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:City><st1lace>Toronto</st1lace></st1:City>",J2<20)),"Matched","Not Matched")
<o> </o>
Thanks,
Kashif.

 

[Norie]

In Access the logical operators go between the arguments, where they should be really.

So your Iif statement might look something like this.


=Iif([Amount]>0 Or ([City]<>'Toronto' And [Amount]<20), 'Matched', 'Unmatched')