View Full Version : Displaying a Date Range on a Report


Sol
03-08-2000, 12:26 PM
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
03-08-2000, 12:52 PM
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
03-08-2000, 01:56 PM
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
03-08-2000, 02:02 PM
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
03-08-2000, 02:07 PM
In your Control Source line for your text box on your report, insert the following:

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