Displaying Parameter in Report Header

[ineedyourhelp]

I have set up a parameter query that prompts for a Begin Date and End Date. This query is linked to a report. I would like the dates selected to appear in the report, but I have been having some problems.

I have read that you can set the parameter directly from the report, which I have tried by using the following.

"Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " & [Enter End Date]

The dates that I select appear correctly, but the data that is returned is not accurate.

I then set up the parameter in the query and then used the above in the report as well. This time, the dates appear correctly, the data IS accurate, but I am prompted 4 times instead of 2.

Is there any way to have the dates appear in the report without getting prompted more than twice and still maintain accuracy?

 

[Crowley16]

well, if your report is reporting the wrong dates, then there's probably something wrong with your report or the underlying query of your report...

personally, I would just put these 2 dates into a form, and then have a command button which opens up the report, that way, I can reference the dates on the form either in query or report or both...

 

[ineedyourhelp]

I have used your suggestion and created a form with drop down options for dates. I am unsure how to link this form with the query/report so that the query will recognize the dates that are entered into the form.

Thanks