G Guest Dec 21, 2003 #1 If I wanted to check if a certain field contains certain value, and return "yes" or "no", what would be the appropriate query?
If I wanted to check if a certain field contains certain value, and return "yes" or "no", what would be the appropriate query?
A aa Dec 23, 2003 #3 How can I use for my purpose? Dan Artuso said: Hi, Check out the IIf function in Help. Click to expand...
How can I use for my purpose? Dan Artuso said: Hi, Check out the IIf function in Help. Click to expand...
R Rick Brandt Dec 23, 2003 #4 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")
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")
