Sep 05 2022 08:11 AM - edited Sep 05 2022 08:31 AM
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.
Sep 05 2022 09:49 AM - edited Sep 05 2022 10:19 AM
SolutionHi,
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
Sep 05 2022 09:52 AM
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]".
Sep 05 2022 10:07 AM - edited Sep 05 2022 10:17 AM
> 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
Sep 06 2022 01:43 AM
Sep 05 2022 09:49 AM - edited Sep 05 2022 10:19 AM
SolutionHi,
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