Print Data Range on Report

[Dale S]

I have a report that requires a beginning and ending date to be entered by the user. The report is tied to Qry_Second_Stage_04 that is tied to an earlier query called Qry_Downgrades where the beginning and ending are listed as criteria for a field called Production Date. What do I enter in the Text Box so that the beginning and ending date will show up on the report? Also, how can I get the dates to show up on each page of the report?

[pbaldy]

I assume you're using something like [Enter start date] as a criteria, in which case you can have a textbox in the page header with a control source of:

=[Enter start date]

You can also concatenate both into a string.

[Dale S]

It worked! Thanks. Ended up using a text box for the [Start Date] and a text box for the [End Date]. Then I put a label in between with the To in it. Turned out great. Much appreciated.

[pbaldy]

Happy to help. You can also do this type of thing:

="From " & [Enter start date] & " to " & [Enter end date]

[Dale S]

Happy to help. You can also do this type of thing:

="From " & [Enter start date] & " to " & [Enter end date]

Tried something similar to that but it did not work. What I tried was
=[Start Date]&"To"&[End Date]

[pbaldy]

You'd want spaces around the &, but it should have worked. What went wrong?