Thanks a lot.
Krishnadas
--- In [email protected], "J. Mitchell Grossack"
<[EMAIL PROTECTED]> wrote:
>
> --- In [email protected], "Krishnadas Rai" <krishnadasrai@>
> 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/
