crosstab query problem

[dbertanjoli]

Hello,
I created a crosstab query and I would like to add this criteria to it: [Forms]![Main]![ID] but I am getting Microsoft Jet Database message that this is invalid criteria. IIt works when I test it in regular query. Can please someone tell me what I am doing wrong and is there any way around this problem?

many thanks

 

[ByteMyzer]

Could you post the SQL Statement from your query?

 

[dbertanjoli]

Here it is:

TRANSFORM Max(CStr(Trim([Answer]))) AS FullAnswer
SELECT owsResponseAnswer.ResponseID
FROM owsResponseAnswer INNER JOIN owsQuestion ON owsResponseAnswer.QuestionID = owsQuestion.QuestionID
WHERE (((owsResponseAnswer.ResponseID)=[Forms]![Main]![ID]))
GROUP BY owsResponseAnswer.ResponseID
PIVOT owsQuestion.Description;

Many thanks,
Deb

 

[pbaldy]

Crosstab queries require parameters be explicitly declared:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

 

[dbertanjoli]

But how to associate that paramenter to choosen ID. I want ResponseID to have this parametar: [Forms]![Main]![ID]

 

[dbertanjoli]

It is working when I entere criteria under responseid and parameteters.

Many thanks,
Deb