Range of date in a report

[delaikhi]

Hi there, I have a question:
I put dates in a range like this in a query: between #03/26/2014# and #04/26/2014#. Now, on the report based on this query, I want to put a field that displays the months that reflected in the query. Any way to do this? Thanks a bunch

[pbaldy]

It would be very unusual to hard code dates into a query like that. Most of us would use a form for the user to enter dates, alternatively you can have

Between [enter start date] And [Enter end date]

Either would be more dynamic and either will let you put the same dates on the report.

[delaikhi]

Hi Paul,
That what I am trying to do. In fact I, have a form to pick dates and than it would reflect on a query. It runs OK with the query, but when it comes to the report, it would not show the date range that I put on the previous form. What I really want to do is to have a field that automatically says: ORDER REPORT from 03/26/2014 to 04/26/2014. Thanks

[pbaldy]

A textbox with a control source like:

="From " & Forms!FormName.FromTextbox & " to " Forms!FormName.ToTextbox

will show the dates. Change the items in red to your names.

[delaikhi]

Thanks a bunch, Paul, awesome

[pbaldy]

Happy to help, and welcome to the site by the way!

[delaikhi]

Happy to help, and welcome to the site by the way!

Paul, 1 more quick question, how can I put that in a specific format like: dd/mm/yyyy?

[pbaldy]

Wrap each form reference in the Format() function.