wrong total amounts in report

[pablavo]

Hi there.

I've made a report and am having a problem with it.

I have three group headers in the report.
One is for the names of organisations
One with all the projects within that organisation.
And one header with all the payments to the projects.

So I have the Organisation footer and in that I have the txt box that will calculate all the payments together that were givin to that Organisaton.
I'm using =Sum([AmountApproved]) Simple
The problem is that for some Organisations totals i'm getting the correct amounts and for some I'm not.

One organisations actual spent amount is £177,426 but Access is calculating it as £408,736.

I don't know what I'm doing wrong. Maybe it's something to do with the way I've grouped the fields.
I don't have the Calculation txts as running sums.

has anyone had this before? and if so, does any one have any suggestions?

Thanks

 

[burrcm]

I would suspect that the ones which are working have only one entry, and the ones which don't have more than one. The total shown would be the last detail entry for that organization. Resolve this by using a running sum in the detail section (hidden) then you should get the correct total of the same named field in the organization footer.

Chris B

 

[pablavo]

Duplicates

Thanks BURRCM for replying.

Well, this is strange. I had the details about the amounts etc in the "AmountApproved" Header and because of this, I didn't make use ot the detail section.

I put the amounts into the details section and what I get is duplicates. Some records are fine, others repeat the amount. I've checked the backend data and there definintely isn't a duplicate there. So I'm confused as to where some of these duplicates are coming from.

I must have something linked incorrectly or I've incorrectly developed the report.

Have you ever saw anything like that?

 

[pablavo]

Query

I've had a look at the query which I should have done well before this and it's this that's giving me the duplicate. I've tried different join types and that's not really working

Does anyone have any suggestions for me to try?