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