Add date range to report

[Zeppelin]

When I run my reports they kick off a date range selection I have in the queries. (between date a and b) I want to take that value I put in when prompted and have written to the header of my report so I dont have to keep manually changing the text on the report.

 

[bjackson]

do you open the report from a form or
do you just use the database window

if you open them from a form then all
that is required is a text box in your report header
with its control source set to

="Between" & forms![formname]![yourstartdate text box name] & " - " & forms![formname]![yourenddate text box name]

 

[Zeppelin]

The date range is on the querie and I run it from either the report section or a form so I need it to work directly from the report.

The querie field:


Field (Case_Completed)
Criteria Between [Start Date] and [End Date]

 

[ColinEssex]

In the report header put

="Between " & [Start Date] & " " & [End Date]


as the ControlSource of a textBox


Col

 

[Zeppelin]

Close this thread and give that man a Cigar

Thanks, that is exactly what I needed.