Re: If then statement in a query

J

Joe Fallon

You can nest them inside of each other if you want.

IIf(condition, true, iif(condition, true, false))


That gets pretty confusing pretty quickly.
I would write a VBA function where you could "spell out" the requirements in
a cleaner way.

If condition then

else
If other condition then
else
end if
End if
 

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

Support for CASE statements in SQL 2
Nested IIF Statement syntax(?) problem 4
Nested IIf Branches 2
IIF statement in MS Access Queries don't return "false argument" 1
Help with IIF in Criteria 1
IIF() in MS Access query 5
Alternatives to Nested If statements? 10
IIF() please help 5

Top