Display my criteria as my report header?

[ajhts]

I have a report, when I run it, it asks me for
Month, Beginning Day, Ending Day, Year. Then it prints all of my results for me just fine.

My current report header shows the Month and Year for the report printed.

They want to see the Beginning Day and the Ending Day on the report header so they know which day range they are looking at.

All of this is set up on the query under criteria. For example my day criteria shows this: Between [Enter Beginning Day] AND [Enter Ending Day]

If they enter day 1 through 14, how do I get this to show up on my report header so they can see that the report consists of days 1 through 14. I hope I explained this.

In case you are wondering, they do not want them to enter it as a date due to some other reasons. When they enter the data, they enter the month= 7, Day= 1, Year= 2004. All three separate fields. Thanks for all of the help!

AJ

 

[Blorf]

Easiest way is to change the way you do this.

If you make a form Called Criteria and add unbound text boxes and name them [StartDate] / [EndDate], you can change the query to read like

Between Forms!Criteria!StartDate AND Forms!Criteria!EndDate

Then you can add unbound controls to your report, with =Forms!Criteria!Startdate as the control source.

ChaZ




"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert