Recent content by his65

Oh, just one more piece of info...If I don't open the query at all, it works fine!! Only when I open the query do I get this message and the statement changes from commas to vertical lines (|).

CraigDolphin, Thanks for the reply. Some info concerning my query...The [category] will always be a number from 1-4. They are pre-entered by me and will never be null. I changed my query from the IIF to the Switch statement and I still get the same error: Expression you entered contains...

I've been using the nested IIF statement in my query using MS Access 97. I'm trying to use it MS Access 2003 and its coming up with syntax errors. The first thing the query does to my statement is convert the commas to vertical lines (|). When I change it back to commas, I still get a syntax...