Hi,
I'm trying to modify a sample database and came across this query:
Code:
PARAMETERS [[Forms]!fmnuReportSelect![cboSrvID]] Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns
SELECT tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2, tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns, tblQuestions.SrvID
FROM tblQuestions INNER JOIN tblResponses ON tblQuestions.QstnID = tblResponses.QstnID
WHERE (((tblQuestions.SrvID)=[Forms]![fmnuReportSelect]![cboSrvID]) AND ((tblQuestions.QstnType)="Stat" Or (tblQuestions.QstnType)="Demo"))
GROUP BY tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2, tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns, tblQuestions.SrvID
PIVOT "Number of Responses" In ("Number of Responses");
However a syntax error is flagged by Access if I try to make any changes. It says:
"Syntax error in PARAMETER clause".
Does anyone know what's wrong with it? I suspect it's the name of the variable itself.
Thanks!