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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing the date range based on entered parameters

Status
Not open for further replies.

cschinelli

Programmer
Jul 22, 2004
13
0
0
US
I can do this in a report by making the ControlSource of a text box the same as the Parameter name in my query (example: criteria for the date "between [FromDate] and [ToDate]" makes the query ask for a FromDate and a ToDate)

I want the entered dates on the report? thanks
 
Doesn't your first sentence answer last question?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
yes,my appologies, how is this done in an Access page?
 
If you want to print the date in the report, you would enter something like this in the "Control Source" property of a text box:
="Report Generated Between " & [FromDate] & " - " & [ToDate]

Hope this helps (and what you are asking for!) =)

-DVD Girl
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top