--- In [email protected], "Krishnadas Rai" <[EMAIL PROTECTED]>
wrote:
>
> Dear all
>
> How to use iif and condition in access for matching two values to get
> an output. In excel we use like this - =IF(AND(A2="yes", B2="g1"),
> 200, 300).
>
> Any solution?.
>
> Thanks in advance.
>
> Krishnadas
>
Krishnadas,
In Access we use
:
IIF([YourField1]="yes" AND [YourField2]="g1"),200, 300)
HTH,
Mitch
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
