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

Display a Starting and Ending Time on a report

Status
Not open for further replies.

Cachelot

Programmer
Jan 30, 2001
15
0
0
CA
I really hope someone can help me.

I made a Report with data from a Query, the Report displays data between a specified Starting and End Time; using the following Between statement: "Between [Enter Starting Time:] And [Enter Ending Time:]" in the Query's criteria section of the Time field. The Report works fine it displays the correct information.

However, how can I display in the Report header, the Starting Time and the Ending Time that the user typed in.
 
Set up an unbound text box with its control source something like this:
Code:
="Between " & [Enter Beginning time:] & " and " & [Enter Ending time:]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top