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.
Last edited by Micron; 06-09-2021 at 08:34 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.