Show Date Range in Report Header

[Tophan]

Good Morning,

I have a small problem. I have a report based on a query which requires the user to input the date range. I would like this date range to be a label in the report header. Could someone please help me the formula? The field name is [Job Completion Time] which shows both the date and time an entry was made.

For the previous reports I would run monthly reports only so the report header had the following formula =Format$([Job Completion Time],"mmmm yyyy",0,0) which would display the month and year selected.

At present I am trying to run a report for the period "December 1 2010 to March 31 2011" and would like a formula that would display "December 1 2010 to March 31 2011" in the report header.

Any suggestions?

 

[Access_guy49]

If you use a query with paramaters that must be entered...those paramaters have names example might be... [Please enter start date]
Use THAT name in your previous formula

=(Format$([Please Enter start date],"mmmm yyyy",0,0) & " to " & (Format([Please Enter End date]...blah blah you get it

 

[Tophan]

Thanks...it worked