IIF Function in query

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.
 
L

Lord Kelvan

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
IIF Statement in Query 2
How to display multiple IIf results in one column 1
Multiple Yes/No fields + IIF 2
iif function syntax problem 5
IIF Function Within A Query 6
IIF function help in query 3
Using wildcards in iif in expression builder 3

Top