Report footer

[Guest]

I have a made a report that has one group level that divides work hours by
pay type. In each group the hours are divded by regular and overtime hours
and are summed at the bottom of the section. I need to make a report footer
that will show the sum of regular and overtime hours by pay type, but I don't
know how to generate those sums. Here is what I want it to look like

Regular Overtime
Weekday x x
Weekend x x
Holidays x x

Thanks!

 

[Duane Hookom]

I expect you can create a totals query that looks like this. If so, use the
totals query as the record source of a subreport. Place the subreport in the
report's footer section.

 

[Guest]

=Sum(IIf([Time]="Weekday",[Time]))

 

[Duane Hookom]

IIf() should have three arguments, not two. Also, if the field [Time] might
contain the text value "Weekday", I'm not sure how you could Sum() it.

Try:
=Sum(IIf([Time]="Weekday",[Regular],0))


--
Duane Hookom
MS Access MVP

=Sum(IIf([Time]="Weekday",[Time]))

I have a made a report that has one group level that divides work hours
by
pay type. In each group the hours are divded by regular and overtime
hours
and are summed at the bottom of the section. I need to make a report
footer
that will show the sum of regular and overtime hours by pay type, but I
don't
know how to generate those sums. Here is what I want it to look like

Regular
Overtime
Weekday x x
Weekend x x
Holidays x
x

Thanks!