Displaying Parameter Values in Page Header

[catat]

Hello...



I have searched and searched for this answer.. maybe not enough apparently..
Anyways, I have a parameter query set up asking for two dates, like so... Between [Start Date (dd/mm/yyyy)] And [End Date {dd/mm/yyyy)] .. I would like to have these two dates displayed on the report page or report header. I'm sure it is a simple formula, and I have come across a few, but they have never worked for me.

Thanks for the help! I really appreciate it...

[unnamedplayer]

Hey I actually am working on a report right now and needed the same thing! What I did is in the query that is used for the report, I made sure the Start and End dates were columns and then you can just put a text box in your header and the control source as =[StartDate] or whatever your column name is.

[catat]

Okay, thanks! That worked perfectly!
The reason all of the formulas were not working for me was because I was trying to have the formula [Start Date (dd/mm/yyyy)] And [End Date {dd/mm/yyyy)] all in one text box. I actually created two seperate text boxes... The first with =[Start Date (dd/mm/yyyy)] and the second with =[End Date {dd/mm/yyyy)] .

Thanks so much for the quick reply!

[unnamedplayer]

Actually you should be able to get them all in one text box by doing something like

=[Start] & " - " & [End]

That is what I did in my report so for example the header shows up as 1/1/10 - 1/31/10

[catat]

Ohhh okay, even better! Here I was working on lining up all of my extra text boxes... That works much better. Thanks very much.