Help with a Date Parameter in a Report

Vwilson42

New member
Local time
Today, 07:13
Joined
May 5, 2005
Messages
9
I have a report that was created in a database that was created at least 12 years ago with lots of info and fields. Could use a lot of updating...but my problem right now is that I have a report that was created using a query and it looks like a sub-query? and a date field. The problem is a date parameter has been enter for all three sections--query, sub-query and date field, so when I run the report you have to type the end and start date 6 times. Is there a fix for this? Thanks for any help with this.
 
I would use a FORM for inputs instead of parameter prompts and then you can just refer to a text box on that form for the date. You would have to go into the queries and change the parameter prompt to the form reference like:

[Forms]![FormNameHere]![TextBoxNameHere]
 

Users who are viewing this thread

Back
Top Bottom