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!

Start Date/End Date on a report? 1

Status
Not open for further replies.

rtoguchi

Technical User
Jan 13, 2004
9
US
Hi,
In my query, I filter the data based on a date range. In the date column from my table, I use the "Between [Start Date] and [End Date]." Is there any way to include the dates I am entering onto the report? Like in a text box for "Start Date" and "End Date"?
 
Add a text box with a control source of
="Between " & [Start Date] & " and " & [End Date]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Thank You, it definitely solved the problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top