Crosstab querie

[Omar]

I have a crosstab querie whose criteria is set to:

Between [Forms]![Print_selection]![start_date] And [Forms]!
[Print_selection]![End_date]

This line of code is suppose to get inputs for a between
[start date] and [end date] command from a set of
controls on a print form. But I get an error, even after I
set the value of end_date and start_date on the parameter
menu as date\time.

The error reads:

Microsoft Jet Enginee.. Does not recognize [Forms]!
[Print_selection]![start_date]

Any suggestions, thanks..

 

[Jeff Boyce]

Omar

Can you confirm that the form is opened and the values set? Can you modify
the query and substitute actual dates in the criterion and get it to work?

Good luck

Jeff Boyce
<Access MVP>

 

[Duane Hookom]

In addition to Jeff's comments, you must specify the data types of all
parameters in crosstab queries. Select Query|Parameters and enter
[Forms]![Print_selection]![start_date] Date/Time
[Forms]![Print_selection]![End_date] Date/Time