IIf statement in query to return "Or" result

[mlrucci]

Good afternoon, I am attempting to use an IIF statement to return 2 or 3 or 4 if a value is true. I have tried multiple variations without success. If the statement is false, it returns the correct value. The problem is if the statement is true, it will not return the true value. Here is my IIF statement



IIf([Forms]![frmInvoiceDataPopUp]![txtSOWID1]=2 Or 3 ,2 Or 3 Or 4,[Forms]![frmInvoiceDataPopUp]![txtSOWID1])

Any insight would be helpful!

[Micron]

If I walked up to you and said "2 or 3" what would your reaction be? That is what you're saying to Access. Each comparison operator must be qualified, as in (e.g. for x)
IIf x=3 OR x=4 OR x=5... Your x is [Forms]![frmInvoiceDataPopUp]![txtSOWID1]
However, you can't have "2 Or 3 Or 4" as the value part for when the test is true. Why would you make the 'if true' value arbitrary? The switch function might be better (assuming one can use it in a query) but I don't know as the expression seems a bit odd.

[NoellaG]

If you want to return the true value in case txtSOWID1 = 2 or 3 you need to specify this as:

IIf([Forms]![frmInvoiceDataPopUp]![txtSOWID1]=2 Or [Forms]![frmInvoiceDataPopUp]![txtSOWID1] = 3 , ...

Next, you need to specify 1 value that the function needs to return in case of true. You can't expect the computer to make a random choice.