How to Subtract 2-Sums on a report?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

My report list product sales.
It groups on Product Number and on Sale or Return

If Sale is True then Qty_Shipped is how many we shipped for that order
If Return is True then Qty_shipped is how many we got back... (returned
products)

I have it summing Qty_Shipped like this =Sum([Qty_Shipped])

And it sums the Qty_Shiped for Sales and it sums Qty_Shipped for Returns.

How can I get it to subtract the Returns from the Shipped so I have net new
products shipped?

thanks for any help.
 
NewProducts Shipped:(Sum([Qty-Shipped]) - (Sum([Qty-Shiped]))) This would
appear in a query. If you are using a textbox on a form or report, then drop
the Field Name and type = instead in the textbox Control Source. You may
have to tweak the parthenses.
 
Back
Top