Darrell
Registered User.
- Local time
- Today, 11:01
- Joined
- Feb 1, 2001
- Messages
- 299
Going down a death spiral on this one and have finally given up...
I have a report based on a query of orders vs deliveries. For each item in the order there may be several deliveries as they can be spread over a time period.
So in the report, it shows duplicate lines for the order item (Inv Code) and order qty and of course then gives the wrong totals for order qty.
The order I am looking at has only one Inv Code and an Order Qty of say 500.
The delivery is split over 3 dates. Qtys are 400, 50 and 50.
On the report it is showing 3 rows and I have set the property of the Inv Code to HideDuplicates.
I have added the following
And this works fine.
However, the sub total for the Qty Ordered (in a Customer order footer) is showing 1,500 so I would like to use the same property to make it only show the actual value but have hit a brick wall with how to go about it.
All help greatly appreciated. Thanks
I have a report based on a query of orders vs deliveries. For each item in the order there may be several deliveries as they can be spread over a time period.
So in the report, it shows duplicate lines for the order item (Inv Code) and order qty and of course then gives the wrong totals for order qty.
The order I am looking at has only one Inv Code and an Order Qty of say 500.
The delivery is split over 3 dates. Qtys are 400, 50 and 50.
On the report it is showing 3 rows and I have set the property of the Inv Code to HideDuplicates.
I have added the following
Code:
Private Sub Detail_Print(Cancel As Integer, FormatCount As Integer)
If Me!InventoryCode.IsVisible Then
Me![Qty Ordered].Visible = True
Else
Me![Qty Ordered].Visible = False
End If
End Sub
And this works fine.
However, the sub total for the Qty Ordered (in a Customer order footer) is showing 1,500 so I would like to use the same property to make it only show the actual value but have hit a brick wall with how to go about it.
All help greatly appreciated. Thanks