Grand totalling

[Guest_imported]

I have my total in the report footer that seems to not add my hours field correctly.
It wants to add it for each JobModify_hours. So if I have two JobModify_hours
it will add the hours field twice in the total such as:


Job_id hours JobModify_id JobModify_hours
1 10
10 5
11 20

Job_id hours JobModify_id JobModify_hours
2 20
12 30
13 10

##this part is in my report footer
Total Hours = 60 ###THIS NUMBER SHOULD BE 30
Total JobModify_Hours = 65


I am using the [tt]Sum=([hours])[/tt] BUT want to make the hours field distinct so I can get the correct sum.

Please advise.

 

[GingerR]

does Job_ID have it's own header and footer?

if not go to SORTING AND GROUPING, group on Job_ID, make it have a header and footer and put your Job_ID and hours in the Job_IDHeader, and put your calculation =sum(hours) in Job_IDFooter instead of the ReportFooter.

g

 

[LittleSmudge]

My interpretation on what you're asking

Do as GinderR says - up to:- put you calculation = Sum(hours)

I'd say put a field = (hours) in the Job_Id footer
Make that field .Visable = False and the SUM over all.
Then in ReportFooter set ControlSource = FieldName of field in Job_Id footer

This is because you want the answer to appear in the Report footer rather than subtotals in the sections I believe.


G LS

 

[shanewa]

Good advice LittleSmudge and GingerR. I tried it and it worked. I wouln't use the group footer visable or not visable, just go with the report footer having the sum.