Crosstab paremeter query help

[MadMax7]

Hope someone can help

i have the following code

PARAMETERS [Between [forms]![frmPreviewReports]![txtStartDate] And [forms]![frmPreviewReports]![txtEndDate]] DateTime;
TRANSFORM Count(qryClusterA.ClusterXfers) AS CountOfClusterXfers
SELECT qryClusterA.Interval, Count(qryClusterA.ClusterXfers) AS [Total Of ClusterXfers]
FROM qryClusterA
GROUP BY qryClusterA.Interval
PIVOT qryClusterA.BranchCode;

the problem i am having is when i try to run the crosstab query i am getting a error saying invalid bracketing of name '[Between [forms]![frmPreviewReports]![txtStartDate] And [forms]![frmPreviewReports]![txtEndDate]]'

i have tried removing the last ] but this has not worked

 

[PHV]

Syntax error in your PARAMETERS clause.
Try this instead:
PARAMETERS [forms]![frmPreviewReports]![txtStartDate] DateTime, [forms]![frmPreviewReports]![txtEndDate]] DateTime;


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886