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

Date display

Status
Not open for further replies.

mattpv

IS-IT--Management
Nov 6, 2001
41
US
I have a query that creates a report. The report requires the user to imput a "starting date" and a "ending date". The report that follows is strictly limited to that date time frame. What I would like to do it put on the header the date period that the user has imput into the query.
Ex:

Shipping Authorization Date Report
(01/01/02-01/31/02)- this being the starting and ending dates entered by the user.

"I get by with a little help from my friends"
 
1. Create an unbound textbox for each parameter in the header
2. Right click and go to properties of the textbox
3. Set the Control Source property to what you specified in the criteria of the query. Ex. Between [Begin Date] AND [End Date]. Set the control sourceof the first textbox to [Begin Date] and the second to [End Date]
4. To see all in 1 text box use this:

="Between" &[Begin Date]&" and "&[End Date]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top