Date range in acces report

[turks393]

I have a query in access that is bringing up a date range

Between [Enter Start Date (MM/DD/YYYY)] And [Enter End Date (MM/DD/YYYY)]

I then used the report wizzard to make a report and in the header I want to show the date range that was entered. How do I do that. When I add the date to the header it only gives the first date in the range.



Thanks in advance for your help

 

[PHV]

Can't you have 2 controls with the following control source ?
=[Enter Start Date (MM/DD/YYYY)]
=[Enter End Date (MM/DD/YYYY)]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

In addition to PH's comments, IMO parameter prompts are never a good user interface faq701-6763.

Duane
Hook'D on Access
MS Access MVP