Report Totaling Problem

[Guest]

Hello,

I am having a problem where I have a query that runs to create a purchase
order report. For each line on the PO, a record is queried. When there are
notes on the PO, there are multiple records queried per line where only the
notes field is changed. This all works properly but the problem comes when I
try to create a field for the total PO value. I am using the sum function to
calculate price * quantity, but when there are notes, that number is
multiplied bu the number of notes instead of just one time.

Please Help.

 

[Duane Hookom]

The simplest method might be to remove the Notes from the main report's
record source and create a subreport based on the related notes records.

Other methods use running sums on values in group headers.