MS Access IIF instead of LEFT JOIN
Posted on 2011-10-03
I've been working on a fairly large SQL query in Access 2007. I've run into a snag using LEFT JOINs for my lookup tables. More specifically, I've reached the allowable number of JOINS in Access.
I'd like to try to use an IIF statement to try to workaround it but I'm not sure exactly how to do it correctly. My goal is to replace my LEFT JOINS for Yes/No values with an IIF statement so I can free up some JOINS for other lookup fields.
In an attempt to make this work, I placed the following in the "Field:" row of the column in which I'd like Yes or No returned:
This runs but in the returned data I get "#ERROR". Is this possible? If so, do you know where I've gone wrong?