By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 826 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

How to pass parameters to a cross tab query?

P: n/a
I tried to use a combo box on a form to pass a criteria to a cross tab
query. This worked with normal query but not with cross tab. The error
was that the Jet Engine does not recognize it as a valid field name or
expression.

What is the proper way to pass parameters to a cross tab query?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
This is how I do it with Crosstabs which works. Just to give you some
ideas.

Dim QD As QueryDefs, DB As Database, RS As Recordset
Set QD = DB.QueryDefs("yourCrosstabQuery")
QD.Parameters("paramName") = "some Param"
Set RS = QD.OpenRecordset()

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #2

P: n/a
forgot to mention, in the crosstab query you need to right click in the
section where the table list is displayed. This will give you a
dropdown menu. In the dropdown menu click on Parameters. Enter your
parameter(s) and datatype here and click OK and save.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
Thanks

On 29 Oct 2003 21:01:33 GMT, Rich P <rp*****@aol.com> wrote:
forgot to mention, in the crosstab query you need to right click in the
section where the table list is displayed. This will give you a
dropdown menu. In the dropdown menu click on Parameters. Enter your
parameter(s) and datatype here and click OK and save.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.