Print Date Range on Report

B

Boomer

I have a report that is driven by a query. The query
requests a date range for the output. I know there is a
way to get that date range (Start and End) onto the
report thru either a lable or text box but can't remember
how. HELP!!!!!
 
F

Fons Ponsioen

If in the undelying query you have two variables let us
say [Enter Start Date] and [Enter End Date]
you can put on your report in an unbound text box:
="Between "&[Enter Start Date]& " and "&[Enter End Date]
That way it will print out.
Hope this helps.
Fons
 
G

Guest

Thanks- that is what i used in the past and had forgotten.
-----Original Message-----
If in the undelying query you have two variables let us
say [Enter Start Date] and [Enter End Date]
you can put on your report in an unbound text box:
="Between "&[Enter Start Date]& " and "&[Enter End Date]
That way it will print out.
Hope this helps.
Fons
-----Original Message-----
I have a report that is driven by a query. The query
requests a date range for the output. I know there is a
way to get that date range (Start and End) onto the
report thru either a lable or text box but can't remember
how. HELP!!!!!
.
Click to expand...
.
Click to expand...
 
Top