Parameters in Cross tab queries

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

Guest

I am not able to use parameters in cross tab queries. The same parameters
work well in the underlying select queries.
 
In query design view, choose Parameters on the Query menu.

Enter whatever paramters you want, one per line.
Then use exactly the same names in the Criteria of the query.

Declaring parameters is always a good idea, as it helps JET to understand
the data type. In a crosstab it is essential (unless you use the Column
Headings property of the crosstab query.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Running Sum in Cross Tab Query 0
crosstab query with datea parameters 2
Parameters error in Cross Tab Query 0
Parameter Query Won't Run 0
Cross-Tab Query 2
Using automation to load a cross tab query to Excel 11
Cross tab Parameter that uses like operator 2
Query question 3

Back
Top