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

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

Month Report with Weeks 5
Chart not working in report - Help requested 5
Summary pages on Reports Query 3
Summary Report 2
Display a weekending date even if there is no data 5
Totals are doubled when report is a sub report 3
Running total by group 1
Access Report - Field to toal Group Totals 1

Top