Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I get a date range to print in a report header?

Status
Not open for further replies.

mattdee

Technical User
Jan 14, 2004
2
US
I frequently use date ranges Between[Enter Start Date]and [Enter End Date] as criteria in my queries. Is there a way to get the input dates to appear in a report header without having to input the date range twice? Thanks Matt.
 
Add a text box with a control source of:
="From " & [Enter Start Date] & " to " & [Enter End Date]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Duane,

Thanks for your help, it worked perfectly.

Matt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top