Crosstab Qry does recognize another Qry's Between Dates

[penwood]

I have a Qry1 that contains a criteria of:
Between [Start Date] And [End Date]

I eventually use a crosstab Qry2. The wizard does just fine.
but when i run the crosstab, i get an error message:

"the microsoft Jet engine does not recognize "start date" as a valid field name or expression."

Is there anything i can do?

Penwood

 

[EMP]

You can open Qry1 in query design view, select menu Query, Parameters... and declare the data type of each of the parameters [Start Date] and [End Date].

^

 

[penwood]

It works. Thanks so much. You are amazing. First time i had a need to use that qry, paramater box.

Penwood