Reports

[mustangric2001]

I have a table for entering tickets, there is a date, violation, and a fine
feild. I have made are report that adds all the fines together. The report
adds all of the new enteries ont it. What I want to do is each week print
out a report with only that weeks information on it but the report shows all
of the information on it even when I filter my table. I was able to make a
new report with the filter information but had to built it all over again. Is
there a way to set up a report and only us it when I filter the information.

 

[John Spencer]

Base the report on a query.

In the query
Field: DateFieldName
Criteria: Between DateAdd("d", 1-Weekday(Date()), Date()) AND
DateAdd("d",7-WeekDay(Date()),Date())

That criteria should always run the current week.

If you want the prior week, you can try
Criteria: Between DateAdd("d", 1-Weekday(Date())-7, Date()) AND
DateAdd("d",-WeekDay(Date()),Date())

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..