Setting a Date Range upon Opening a Report

  • Thread starter Thread starter wessleym
  • Start date Start date
W

wessleym

I would like to be prompted for a date range when I open
a certain report. The tables have been created and
everything. I just need to somehow know to prompt me for
a date range before the report is generated.
 
Hi,
Open up the report properties. Under Filter, type:

yourdatefield>=[Enter start date] and yourdatefield<=
[Enter end date]

Set the FilterOn property to "Yes"

Hope this helps.
 
Back
Top