Wrong number of arguments in Duane's Concatenate Module 2

[NeilT123]

I am trying to use Duane's Concatenate module to create a report label but I keep getting a "wrong number of arguements error message. My code is

SELECT tblSltFarm.FarmAccountNumber, Concatenate("SELECT AccountName FROM QrySLTFarm2
    WHERE FarmAccountNumber =" & [FarmAccountNumber], ", ", ", and " ) AS AccountNameLbl
FROM tblSltFarm

Can anyone point out where I am wrong please.

Thank you

 

[dhookom]

I have updated the function at faq701-4233. Please replace your function with the new one and test it for me ;-)

Duane
Hook'D on Access
MS Access MVP

 

[NeilT123]

Yes that works for me, the spacing and positioning of the commas are all good and it now handles single values.