date range parameter on report

hlacroix

Registered User.
Local time
Today, 02:55
Joined
Jan 10, 2008
Messages
13
Hello,

I had a date range parameter, ="From: " & [start date] & " To " & [end date] on my report.
When I enter a start date and an end date, I am prompted for the range again. To troubleshoot, I removed the range, either from the properties box or just delete it from the control itself. When I ran the report, the phantom prompts for a date range still appear. If I delete the parameter from the underlying query, and then run the report, the prompts don't show. When I reenter the parameter to the query and run the report, I again am prompted twice for the same range. When I run the query, I am only prompted once.
How do I correct this parameter problem?

Thank You
 
Try:
From [Start Date] to [End Date]
without the ampersands (&).
You should be promted for a start date and end date once.
 
Thanks statsman,

that did the trick.
 

Users who are viewing this thread

Back
Top Bottom