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.
Any ideas how to do this?
Gracias.
|
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] |