how to set date range for report?

  • Thread starter Thread starter leo
  • Start date Start date
L

leo

Hey I created a report based on how well our account
managers are costing projects, however I don't want the
report to print out every single entry, I would like it
to print out either entries within the last 30 days or 7
days... can this be done?
 
You should have the report run from a Query that pulls
from the table where the projects are. Use two reports
and two queries. The queries are exactly the same and so
are the report with one exception

One query has a criteria of Today and last 7 and the other
does the same with today and last 30.
 
Leo,
Base the report on a query.

If it's always going to be a number of days back from the current date....
In the Query date field, enter, on the criteria line:

Between Date() and (Date() - [How many days back from today])

When prompted, enter 7, or 30, or whatever.
 
Back
Top