Use single date range to export multiple excel spreadsheets

[imonline]

I've created a macro that exports from Access 20 some odd Excel spreadsheets. My only problem is for each report a popup comes up asking for the Start Date and the another asking for the End Date.



Is there a way I can put the Start and End date only once to run these reports?

Any help would be appreciated.

Thanks

[ranman256]

put it on a form.
the form has txtStartDate and txtEndDate.
the query would reference this.

select * from table where [date] between forms!frmRpt!txtStartDate and forms!frmRpt!txtEndDate

[imonline]

put it on a form.
the form has txtStartDate and txtEndDate.
the query would reference this.

select * from table where [date] between forms!frmRpt!txtStartDate and forms!frmRpt!txtEndDate

Thank you!!!