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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range on Report 6
Crosstab Date Range in Reports 3
Crosstab Query and Date Parameters 10
How to show qry "criteria" on a report ? 10
Date range in a report 2
Covert report to PDF 4
Date Range on a report that has multiple date dependent sub report 1
Date Range 3

Back
Top