Crosstab query based on another query

  • Thread starter Thread starter Nellie
  • Start date Start date
N

Nellie

Ok...here's the scenario:

I have an existing query that runs based on date range and
choosing a particular customer off a list....what I am
trying to do is run a separate crosstab query based on the
above query including the date and customer and some
values....but when I try to run the crosstab it tells me
that it does not recognize the form as a "valid field name
or expression". Does that make sense? I am not sure what
to do. Any help will be greatly appreciated.

Thanks!
 
First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2
 

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

Crosstab query error 1
Crosstab Query based on Query 4
crosstab query with parameter query 5
Parameter Queries in Crosstab Query 2
Help on crosstab query 2
crosstab query parameters for dates 1
Query a crosstab query 2
Parameter Value in Crosstab Query 4

Back
Top