cross tab query

L

liva

I have a table with 3 columns
Id Product1 Product2
I made a select query with expression

Select Id, Product1, Product2 where Product1= Forms!Form1!
Combo1
This query is working fine

But I want to make a cross tab query from this select
query. When I try to make that, I am getting error
like "Microsoft Jet engine not recognizing Forms!form1!
Combo1.

Any Solution, really appreciate your help
 
D

Damon Heron

You want to fill in the parameters query dialog box. Get there by
right-clicking on your query screen and select parameters.

Damon
 

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

help on a formula (match and etc..) 1
How to display zero value in blank fields of Cross Tab query 0
Using a combo box to see whether companies have certain products 1
Want a Parameter for date range driving a cross tab query 2
Running month sum 2
Cross Tab Report Vs Dynamic coulmns 0
Subtotal query 1
Running a query and setting that value base on another combo box 3

Top