Report footer

T

Tandy

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

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

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


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!
 

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

Top