I have the following problem with crosstab query. I have
designed a crosstab query in design mode and given
parameter as forms!form1!txt1. When I open the same SQL
view, this becomes :
PARAMETERS [[Forms]!form1![txt1]] Text ( 255 );
This now gives me a syntax error on saving. If I correct
it by removing the outer square brackets, it saves fine.
This applies for any crosstab query designed in MS Access
2002. Is this a bug in MS Access 2002 ??