This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When using the iif function I get an error that says 'you omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks'. I get this even when I try:
iif((1+1=2),"yes","no")
I've been working on this for a few hours, trying different things. I called MS support and apparently this is the only forum to get help. Having that function for the work I'm doing is critical. Any suggestions please?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Maths equation error.
IIF((1+1)=2,"Yes","No")
You did not evaluate the value. (1+1=2), you need to change it to (1+1) = 2.
As I mentioned earlier, the simple version DID return the correct result in my IDE, so I don't think it's a bug, per se.
Did you try the variation I posted above? Again, it works correctly on this computer, so it seems to be something other than a bug in Access.
If you want to try to explore further, you could provide a sample accdb with just enough data to test. If so, you could post it on a publicly accessible place like a OneDrive folder and provide a link.
I'm actually encouraged that you got the same error - it's not just me!! Thank you for continuing to look into this.
I've tried three different list separators - comma, semicolon, and pipe. None works.