How to create a report which can be opened depend on date?

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi, I need to create a monthly report. before open, it will ask for input
month, then open report based on that month. I have no idea how to do that,
anyone can help?
Thanks!
 
Min

If you base your report on a query, you can use a parameter in the criterion
for the date field.

This pre-supposes that your underlying data has a date field.

If you include a "field" in your query something like:

ReportMonth: Month([YourDateField])

and put a parameter prompt in the criterion, something like:

[Enter Month Number (e.g., 1-12)]

your query will prompt for a month number, then find the rows where the date
field's "month" matches.

Please note! -- January is January is month "1", no matter WHICH year it
happens. Are you certain you only need to prompt for a "month"?

When your query is working as you wish (i.e., returning the data you
expect), create a report based on that query.
 
Back
Top