concat problem

[leahcim_32]

***i have this query....it has a concatenated field ---rs number

SELECT dbo_MAIN.DATE, dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[OUTLET NO], dbo_MAIN.NAME2, dbo_MAIN.RATE, dbo_MAIN.REMARKS, _
dbo_MAIN.[CUSTOMER TYPE], ConcatRelated("[RS NUMBER]","[waybill list query]",_
"[OUTLET NO] & [VISIT FORM NO]= """ & [OUTLET NO] & [VISIT FORM NO] & """") AS [RS NUMBER]
FROM dbo_MAIN
GROUP BY dbo_MAIN.DATE, dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[OUTLET NO], dbo_MAIN.NAME2, dbo_MAIN.RATE, dbo_MAIN.REMARKS, dbo_MAIN.[CUSTOMER TYPE]
HAVING (((dbo_MAIN.DATE) Between [FORMS]![RSWAYBILL]![BEGINDATE] And [FORMS]![RSWAYBILL]![ENDDATE]));

**the first query looks to this query to concatenate rs numbers....

SELECT dbo_MAIN.[OUTLET NO], dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[RS NUMBER]
FROM dbo_MAIN
GROUP BY dbo_MAIN.[OUTLET NO], dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[RS NUMBER], dbo_MAIN.DATE
HAVING (((dbo_MAIN.DATE) Between [FORMS]![RSWAYBILL]![BEGINDATE] And [FORMS]![RSWAYBILL]![ENDDATE]));

***and this is my problem everytime i run the first query.....

error 3061: too few parameters. expected 2


help on this pls....
tnx

 

[Alisa]

If you run the query from the query grid, it should ask for the parameters one at a time, that will tell you which fields are not recognized.