crosstab query report

L

Linda Ribbach

I have created a parameter query unlying the report, however, when I click on the report it asks me for the criteria twice. How can I fix this?

Thanks in advance Linda
 
D

Duane Hookom

Opening a report based on a parameter query should only ask for the
parameter once. If you get asked twice for what you think is the same
parameter, I would check:
-the sql view of your crosstab which we can't see
-the control sources bound to the parameters
-the sorting and grouping levels
-are their subreport's involved
-are you being asked once for previewing and once for printing?
 
Top