Wrong Totals in Footer

  • Thread starter Thread starter Dani
  • Start date Start date
D

Dani

This seems to be a common problem, when the totals don't calculate
right in a footer. I am trying to make a report that lists the 5
different types of RESOURCE_IDs, the total number of HOURS_WORKED in
each RESOURCE_IDs group and the number of items produced for each group

I have tried a variety of different scenarios this one being the
closest.

RESOURCE_ID Header:
Name: txtStart
Control Source: CALC_START_QTY
Running Sum: Over Group

Report Footer
Name: StartGrandTotal
Control Source: =[txtStart]
Running Sum: No

But my totals in the footer still don't add up right. RESOURCE_ID
Header shows the correct amount for each resource but it doesn't add
right. And for some reason the HOURS_WORKED field works just fine with
no other manipulation. Just your basic:
RESOURCE_ID Header:
Name: sum HOURS_WORKED
Control Source: =Sum([HOURS_WORKED])
Running Sum: No

Report Footer
Name: HOURS_WORKED Grand Total Sum
Control Source: =Sum([HOURS_WORKED])
Running Sum: No

Any thoughts? I really bugs me when I can't figure something out.
Thank you to all who have answered my questions in the past.
Dani
 
Dani,

In your underlying query does the field CALC_START_QTY contain what you
expect?

A few sample records and an example of the wrongly calculated footer would
help.

Terry
 
Terry, CALC_START_QTY does contain what I expected. Just numeric
accounting of the number of parts for each resource. Here is a copy of
the report.

RESOURCE_ID sumHOURS_WORKED txtStart txtEnd
225-230-389 13.63 6 6
225-320-414 18.29 12 12
225-410-381 5.1 18 18
225-620-281 1.29 24 24
225-640-003 35.39 30 30

The subtotals should be 73.7; 90; 90

However in the report footer the sumHours_Worked are correct but start
and end qtys are 30; 210. Have no clue how that total is arrived at.

Any ideas?

Danielle
 
Back
Top