Crosstab query - date problem

[Butch]

I developing a crosstab query. But the query,(query A), it's pulling the information from has criteria under the 'date' field.
The criteria is:
>=[forms]![frmDateRange]![txtStartDate] And <=[forms]![frmDateRange]![txtEndDate]
and this works ok in 'query A'.

but when I design a crosstab query using information from 'query A' I get an error:
The Microsoft Jet database engine does not recognise '[forms]![frmDateRange]![txtStartDate] as a valid field name or expression.

I can get the crosstab query to work if I set up paramaters but for reporting reasons I need to be able to input the dates from frmDateRange.

Thanks four your help in advance

 

[pbaldy]

Parameters for crosstab queries must be explicitly declared.

Go into design view, then Query/Parameters and enter them in the list.