Report Totaling Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top