I have created an MS Query from Excel that pulls data from a table in an Access Database. I'd like to create a new field for the query only. I know if/when I do this in Access, the format of a formula that uses iif is expressed as:
I'm trying to do a similar format in the MS Query, but it's not accepting it. I'm assuming that the format is slightly different. Can someone help?