query to check if a certain field contains certain value, and return "yes" or "no"

Guest · Dec 21, 2003

If I wanted to check if a certain field contains certain value, and return
"yes" or "no", what would be the appropriate query?

Dan Artuso · Dec 21, 2003

Hi,
Check out the IIf function in Help.

aa · Dec 23, 2003

How can I use for my purpose?

Dan Artuso said:
Hi,
Check out the IIf function in Help.

Rick Brandt · Dec 23, 2003

IIf() does a True/False test and returns one value when True and another when
False. That would seem to fit perfectly with your request.

IIf([SomeField]=SomeValue, "Yes", "No")

query to check if a certain field contains certain value, and return "yes" or "no"

Guest

Dan Artuso

aa

Rick Brandt