count weeks in report

  • Thread starter Thread starter Kantor
  • Start date Start date
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
 
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]))
 
Back
Top