Report prompt question

[Crevalle]

I have a report that utilizes an underlying query that prompts for a date range (one prompt asks for the beginning date, the next asks for the ending date--format is: "08/15/2004"). The report displays data for whatever date range the user enters. However, I would like to display, at the top of the report, the date range the user entered. This way if they print it out or give it to someone, it will have the range prominently shown.

Could someone explain how this is done, or point me in the right direction? I've done searches here, but to no avail. Thanks--I'll keep checking back!

 

[M8KWR]

What i would do is have a form, and have the date input on there, create two text boxes, STARTDATE and ENDDATE, and have a button on there which open the report for the user.

Change you query code to have the start and end date taken from the form

[Forms]![FORMNAME]![STARTDATE]
[Forms]![FORMNAME]![ENDDATE]

In the report header insert a text box, and you would say something like



="The Report display records between " & [Forms]![FORMNAME]![STARTDATE] & " to " & [Forms]![FORMNAME]![ENDDATE]

 

[Crevalle]

M8KWR--I appreciate the detailed recommendation, but I think you've eclipsed my knowledge of Access. I have no experience with forms, or SQL. Is there any method more straight-forward or less complex?

 

[CosmoKramer]

While using text boxes on a form is the preferred method, you can utilize the parameter prompts in your query. Add a text box to your report whose control source is like this:

="For the dates " & [Enter Beginning date] & " to " & [Enter Ending date]

where the parameters are spelled EXACTLY like they are in the query....

Hoc nomen meum verum non est.