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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I wanted to check if a certain field contains certain value, and return
"yes" or "no", what would be the appropriate query?
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access how do you set a yes/no data type as required? 0
Checking if data exists another table and, if yes, extracting a value 0
Excel Lotto - How to find duplicate 6-number groups from result database? 2
Don't want a return if it exists in another table 6
Update Query 10
Query criteria - exclude data and return all records if null 3
Date range in a query 1
Evaluate Yes/No Field Based on User Input 7

Back
Top