Count # ckbxs chkd (mon-fri) in rpt rec to count wkly sessions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that lists in the detail section: Facilitator, GroupID,
School Name, #Students, #Sessions, Start Date, End Date, Start Time, End
Time, Mon, Tue, Wed, Thu, Fri....and it groups by Facilitator. After each
Facilitator grouping it shows the total number of groups, sessions, and
number of students...and at the end of the report is shows the Grand Total of
number of groups, sessions, and number of students.

However, here is my delima:
The #Sessions is a DateDiff function (=DateDiff("ww",[SDate],[EDate])+1)
that counts the number of weeks between the Start Date and End Date, but I
forgot to take into consideration that some Groups may meet 2x/week. So now
I need to figure out, for example, the number of Mondays AND the number of
WEDNESDAYS between the Start Date and End Date if in fact that particular
groups meets Mon AND Wed of each week as to apposed to just meeting on Monday
of each week.

Any tips for me, please?
Thank you.
 
Cheryl:

Add a field something like SessionsPerWk to the table that holds the session
data with a default value of 1. Then if you set a value of 2 for a
particular group, you can simply add to your current DateDiff function
(DateDiff("ww",[SDate],[EDate])+1) )* [SessionsPerWk]
 
Back
Top