Report Parameters

T

Tom

I am trying to include criteria parameters on a report from a crosstab query.
the criteria written is "Between [Start Date] And [End Date]" and it works
well. When I try to include them in my report, I get a message #Error#. How
can I make this work?
 
D

Duane Hookom

How are you trying to include them in your report? I think you can get
around this by creating two new columns as Row Headings in your crosstab
StartDate:[Start Date]
Row Heading
and
EndDate: [End Date]
Row Heading

This will only prompt you once per unique parameter and will create extra
columns with your values.
 
Top