Displaying a Date Range on a Report

[Sol]

I'm trying to have my report display the date range which the user enters in to the prompts?

Any ideas how to do this?

Gracias.

 

[tracey75]

I have the same problem. I dont know how to put in a date range. So when you find out how please email me or reply back.

Tracey

 

[dennyryan]

I base almost all of my reports off of queries. In that situation, I build the parameter prompt there:

In the Criteria section of the grid:

Between [Enter Start Date] and [Enter End Date]

It's a little friendlier to front-end this with a form but the papramter prompts aren't the worst thing a user is likely to encounter.

Denny

 

[Neal]

I you use a form to enter the parameters, you can refer to the fields in the report.
Something like this:
[Label that says "Report for" [forms!yourformname!Begin] [Label that says "through"] [forms!yourformname!End]

 

[Carol]

In your Control Source line for your text box on your report, insert the following:

="Report Between " & [Forms]![InputDialogBox]![FieldName] & " and " & [Forms]![InputDialogBox]![FieldName]