CrossTab query in SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave L - 31 Oct 2007 14:48 GMT

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

Reply to this Message

Douglas J. Steele - 31 Oct 2007 15:24 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello,
> I need to set-up a crosstab query that will create a recordset of data I
[quoted text clipped - 6 lines]
> Thanks,
> Dave

Reply to this Message

Dave L - 31 Oct 2007 16:01 GMT

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

> Hello,
> I need to set-up a crosstab query that will create a recordset of data I can
[quoted text clipped - 4 lines]
> Thanks,
> Dave

Reply to this Message