count weeks in report

K

Kantor

Hi!

I have a report that is grouped by week. Week 1 with various totals, week 2
with various totals etc.
Now, at the bottom of the report I want to count the actual number of weeks
the report shows.

Please help
 
D

Duane Hookom

If you have an actual date field in your report's record source, you can use
the DateDiff() function.

=DateDiff("WW",Min([DateField]),Max([DateField]))
 
Top