CrossTab query in SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 " & _
 
Back
Top