Can you provide some field names, data types, sample records, and desired
display in the report?


--
Duane Hookom
MS Access MVP


"Lori LeRoy" wrote in message
news
I have a sales order report that I want to display the units ordered
subtotal
if the ship quantity is zero and/or the line item is open; and the units
shipped if the quantity shipped is greater than zero and/or the line item
is
closed. (if any quantity is shipped that line item is closed). currently I
have this for the line item subtotal:
SubtotalSO: CCur(tblSOTransactions.UnitPriceSO*[UnitsOrderedSO])

And it displays the units ordered subtotal regardless of whether the line
item is open or quanities have been shipped, creating a larger total for
the
entire report. I'm sure this is a simple if statement, but I'm at a loss.
Thanks.