Date display

[mattpv]

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"

 

[nfusee]

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]