Hello guys. I have a report which you'll see in both Print Preview and Design view.
Simply put, I want a Total of All Purchase Orders on a Statement, at the summary part below the details. BUT... The total amount shown is incorrect.

In Design view, Each Purchase Order total is [ActCost] and to get the Total of all Purchase Orders at the bottom is =Nz(Sum([ActCost]),0).

Now for some reason it's totalling the top one twice and adding the bottom one to come up with a total way out of range.

I've been at this for a couple of days, and even renewed the Report, but I'm getting the same results.

Does anything obvious stand out? Because if it does I can't see it.

However, if I do a Count of ActCost and just view it in a textbox, it says 3,  not the 2 on the Report.

What have I done?