Parameters in Cross tab queries

G

Guest

I am not able to use parameters in cross tab queries. The same parameters
work well in the underlying select queries.
 
A

Allen Browne

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

criteria in cross-tab query 1
Executing SQL from Cross Tab Wizard in VBA 1
CrossTab Query (SQL View) in VBA 2
Run Multiple Update Queries at Once 6
Cross Tab Query Paramenters Not Working 2
Cross-tab query parameters 27
Cross tab Query 3
passing parameters from one query to another 2

Top