Footer totals

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

Mike D.

Here's an example of what I want my form to look like -

Machine# Hours Notes
------------------------
1 3.2 xxxx
1 2.8 xxxx
1 2.0 xxxx
Total 8.0
------------------------
2 3.0 xxxx
2 1.0 xxxx
Total 4.0
------------------------
3 2.5 xxxx
3 2.0 xxxx
3 1.5 xxxx
3 1.5 xxxx
Total 7.5
-------------------------
-------------------------
(page footer)
Cumulitive total - 19.5


I have no problems except for getting the specific
machine totals. The cumulitive final total shows up
correctly.

I have a footer for machine# that has the name MACHINESUM
and has HOURS for it's control source. The page footer
cumulitive total has a control source =MACHINESUM.

My problem is that specific machine total only shows the
first entry. For example, for machine# 1, it says 3.2
instead of 8.0. I'm surprised to see the page footer get
the correct amount.

Thanks for your help.
 
Mark's question below gave me the answer -
I needed control source to be -
=sum([Hours])

Thanks Mark!
 
Back
Top