CrossTab query in SQL

[Dave L]

Hello,
I need to set-up a crosstab query that will create a recordset of data I can
manipulate for a report. The initial data is ran through a parameter and
then I create the crosstab from the data. When I open the recordset I get
runtime error 3139 for my parameter syntax. I wrote this... " PARAMETERS '"
& [Forms]![reportcenterfrm]![Combo35] & "' " & _. What am I doing wrong?
Thanks,
Dave

 

[Douglas J. Steele]

In the Declaration, the Parameter is the name of the parameter, not its
value. As well, in Crosstab queries, it's critical that the data type of the
parameter be declared:

" PARAMETERS [Forms]![reportcenterfrm]![Combo35] TEXT " & _

 

[Dave L]

Thanks, I had to declare its value alse, but it seems to work.