Report prompting for date range too many times!

[CTOROCK]

I have a report that is linked to a query which is comprised of many. I also have a sub report in there. Everytime I run the report, I have to input the date range about 12 times! But if I run the query by itself, It only asks me 1 time. Can anyone help?

"The greatest risk, is not taking one."

 

[coco86]

I've had this problem with multi-page reports.

One way to solve it is to create a form with a commandbutton to open the report. Add textboxes for the beginning and ending date range. Then modify the query to use the textboxes on the form instead of asking for the date range.



-Coco