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
also you do not need to Concatenate, just use:
IIf([GroupDate] Like "Coming Due*", ...
IIf([GroupDate] Like "Coming Due*", ...