Forum Discussion
Solved
Syntax error - IIF and Dlookup
Hello Experts, I have a union query and I am trying to add a dlookup to it. I am getting a syntax but I dont see where it is? think its on the dlookup part and I have been adding parenthesis bu...
Hi,
From what you posted it looks as if the first IIf is missing its closing parenthesis. So, maybe another ) before " as TEST" does the trick.
Servus
Karl
Access News
Access DevCon
I guess the space in Balance Euro is the problem. It is better not to have spaces in fieldnames. If you do use [.... ] around your fieldname.
So "[Balance Euro]".
> I guess the space in Balance Euro is the problem.
Spaces in field names are not good, of course, but written as a (stand-alone) text parameter inside quotes, they do not require square brackets. So that can't be the problem.
Servus
Karl
Access News
Access DevCon