Report footer

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

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!
 
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.
 
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


dogpigfish said:
=Sum(IIf([Time]="Weekday",[Time]))



Tandy said:
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!
Click to expand...
Click to expand...
 
Back
Top