subtotals or counts in group footer

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
M

Michael Noblet

I have a report that is group by Day and I need to
subtotal encounters durring the day for 3 time ranges.

for example:
sunday 00:00 - 07:00
Sunday 07:00 - 15:00
sunday 15:00 - 23:59

The detail section for the group 3 fields
Date and Day
Time
# of encounters

I need to have in the group footer a total of encounters
for the 3 time groups.

I am sure this is simple but it is escaping me.
 
Michael said:
I have a report that is group by Day and I need to
subtotal encounters durring the day for 3 time ranges.

for example:
sunday 00:00 - 07:00
Sunday 07:00 - 15:00
sunday 15:00 - 23:59

The detail section for the group 3 fields
Date and Day
Time
# of encounters

I need to have in the group footer a total of encounters
for the 3 time groups.

I am sure this is simple but it is escaping me.
Click to expand...


Not necessarily simple. You should have a table that
specifies the time ranges and then use a non-equijoin in the
report's record source query to supply a time range
identifier. This will make it dramatically easier to
redefine the time ranges in the future.

OTOH, you can use a weaker programming practice by
specifying the time ranges in group footer text box
expressions like this:

=Sum(IIf([time] >= #00:00# And [time] < #07:00#,
[encounters], 0))
 
Back
Top