Start and End Dates must appear in the Report

[trident]

I made a query where I need to get the data between to dates.

In the query I mentioned this to be "Start Date and End Date". Whenever, I open the query, it always asks the starting date and the end date of the report.

I transferred the same into a report and it works fine.



Now, I need the dates to be shown as part of the report.

How can I do this.

Your assistance is greatly appreciated.

Thank you.

Trident

[JoeM]

It sounds like you have a Parameter Query which prompts you to enter the dates at run-time. You could show the MIN and MAX dates in returns, but the issue is if either does not exactly match the dates you enter as your parameters, you won't get what you are looking for. I have run into this before, and I don't think you can do it with a Parameter Query.

Here is what I did. I instead made a selection Form, where you enter the date range that you want. I then have the selections in that Form tied to a single line Table, so my entries are stored as Field Values in a Table. So then I can use that Table in my query to both:
- return those two fields as values (so I can show them on my Report)
- use as Criteria to limit my records

[ranman256]

i use a form w 2 text boxes. txtStartDate, txtEndDate.
they are used in the query AND for the 'header' note by making a virtual field:

Header: "From:" & forms!MyForm!txtStartDate & " To:" & forms!MyForm!txtEndDate

[pbaldy]

I do like ranman has shown. That said, you can use your bracketed criteria on the report, like in a textbox:

="From: " & [Enter start date] & " To: " & [Enter end date]

the key being the text must exactly match what was used in the query.