troubleshooting Question

Iif statement needs to account for an or statement value - syntax in Microsoft Access

Avatar of stephenlecomptejr
stephenlecomptejrFlag for United States of America asked on
Microsoft AccessVBA
8 Comments1 Solution74 ViewsLast Modified:
I'm still having trouble with IIF statements and their syntax:

I got this far with this:

IIF(IsNull([JobTicket]), "0" , "1")

The only thing it needs to do if it is Null or 0 then provide the value 0.
Right now it only accounts for Null

JobTicket is a numeric value but I'm providing the strings as text cause it's a field design to do sorting on.
If it should go back to numeric instead then I'd put it back.  But does that change the syntax as well?

Thank you in advance for your comments!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros