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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display a weekending date even if there is no data 5
Running total by group 1
Month Report with Weeks 5
Chart not working in report - Help requested 5
Creating Totals for each COLUMN in a report 1
Adding a field (Unbound field) that adds a group of numbers 3
A03 - count in report footer gives me #Error? 0
Date Format In A Report 2

Back
Top