IIF Function in query

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I need to run a query that run from multiple yes/no boxes on a form. I have
set the form up with the required fields and have place the following into
the critera:
IIf([Forms]![Customer Selection]![Now Account]=No,"null","Yes") I will only
select one yes from the form and then run the query.
 
are you wanting to put this into the databse or just display it on
screen till it is closed for the next time
 

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

If Statement with "*" in Query 2
Multiple Yes/No fields + IIF 2
IIF stmt in Criteria 3
Query IIF function 3
IIF Function Within A Query 6
IIF Statement In Query Doesn't Work Right 3
iif function syntax problem 5
IIF function help in query 3

Back
Top