Forum Discussion
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 but getting nowhere.
below is only the first column of the union query.
UNION ALL SELECT IIf([GroupDate] Like "Coming Due" & "*",IIf(Nz([Amount],0)<0,[Amount]*-1,[Amount]), dlookup("Balance Euro","tblFXParent","IDFXParent =" & IDParentfk) as TEST,
thank you.
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
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- thank you Karl. that was it.
> 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
- also you do not need to Concatenate, just use:
IIf([GroupDate] Like "Coming Due*", ...
