Sum including all records

[Chip]

Hi,
I am having a problem with summing of calculated fields. My report is to
sum the costs for each Purchase Order (PO) listed on the form in the PO
footer of the report. Now the data that I am pulling this from will have
multipleinstances of the PO in the details but I just want the sum of the
Quantity of the PO (POqty) * Price on the PO. I am performing this summing
on the PO Footer but it is summing all of the details for that PO giving an
inflated total. I just want the totals that is shown in the PO Header to be
summed at the bottom of the report and not every line on the report.

I am new to this type of summing so please take this in consideration when
replying, and as always THANKS IN ADVANCE!!!!

Chip

 

[Access101]

Chip,

One SUM error I come across is based on which section I place the statement:

=Sum([PO_Detail_Val])

I could put it in the Report Header, Page Header, Detail Section Header,
etc., and I'll get different results. Though you probably knew that one.

Maybe this is the problem though ... you might be wanting this

=Sum([PO_Header_Val])

instead of this:

=Sum([PO_Detail_Val])

Let me know if this helps.