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

Want to pass variables from a query to a report

Status
Not open for further replies.
Jun 7, 2003
1
US
I have a couple reports that run on a specified time range... 6/19/03 to 6/20/03, for example. Those dates are inputted into the queries that the reports come from (in design view of the queries, they are [Enter Start Date] and [Enter End Date]). How can I display those dates on the reports??
 
Add a text box to your report and set its control source to something like this:
Code:
="For the dates " & [Enter Start Date] & " to " & [Enter End Date]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top