Footer Sum Problem

[anchorp]

I have a report that groups by Date, Job #, Phase #, Unit #, and then Hours. I have a field in the footer under Hours that is supposed to sum the total hours for that group. And it works fine if there is only one job on the report or for the first job on the report. But if there are two or more jobs on the same report then its starts including the last job's hours in the sum. I have attached a screen shot of a two job report. The total at the bottom of the second job is off by two times the total of the first job. This is consistent. If there were three jobs on this report is would be off by two times the total of the first two jobs.

I have tried all the different options on running sums for the field involved and the footer. I am out of ideas on how to fix this. Any help would be appreciated.

 

[boblarson]

It could be because you are trying to get everything via a single query where it should be using separate queries for a subreport where you can total the hours correctly. It is hard to tell without seeing your structure and your design views of things. The quickest way to diagnose, of course, is looking at the database directly (by having you upload it).

 

[gemma-the-husky]

it shouldnt be a running sum

it should just be - =sum(hours)

so it begs the question - what are you doing in this column thats different to the other columns?