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
 
Back
Top