Report Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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