ConcatRelate Error 3061 Too Few parameters

[Rhabdo]

I have been struggling with getting the syntax right for the ConcatRelate function. I have looked at other peoples examples and mine seems to have exactly the same syntax but it is giving me an error.

My Sql is

SELECT qr_RiverGroup.River, ConcatRelated("Site_ID","qr_RiverGroup","[River] = '" & [River] & "'") AS Expr1
FROM qr_RiverGroup;


Any ideas?

 

[jdraw]

Here's the original info.
http://allenbrowne.com/func-concat.html

 

[Rhabdo]

thanks, i have been looking at that page, but i honestly can't see any difference in my code......

 

[stopher]

What's the error? Did you add the code for the function in a module?

 

[Rhabdo]

It gives me an Error 3061. too few parameters. Expected 1.

 

[stopher]

It gives me an Error 3061. too few parameters. Expected 1.

Um, yes you did say that in the title. I should pay more attention. Are you able to upload a sample of the database?

 

[jdraw]

Check your variable/control names-- could be a spelling error.

 

[JHB]

...
My Sql is

SELECT qr_RiverGroup.River, ConcatRelated("Site_ID","qr_RiverGroup","[River] = '" & [River] & "'") AS Expr1
FROM qr_RiverGroup;


Any ideas?

I don't think it is this, but if I compare to the original then you have a "AS Expr1"!
Did you check if you really have a control with the name [River] and that is not empty/null?
Did you check if the query "qr_RiverGroup" has some criteria in it?

SELECT CompanyName, ConcatRelated("OrderDate", "tblOrders", "CompanyID = " & [CompanyID])
FROM tblCompany;