Access Report Display Date

[rki1966]

I want a report that will show the start and end date on the report. I have a query that ask for the start and end date. I just need the report to show the dates on the header.

 

[rki1966]

I have the report I just need the header to show the start and end date which I entered from a msgbox.

 

[Andrew Fergus]

Hi
Whatever criteria you used in your query, use exactly the same expression in the report header. For example, if you used =[Enter Date] into the query, then in your report header, create an unbound text box and set the control source to =[Enter Date]. This usually works ok. If you find it asks for it twice, make sure it is identical but also look at the query parameters under the menu option Query - > Parameters when in the query design screen.
HTH, Andrew

 

[rki1966]

that worked thanks andrew