DSum Criteria

[niuginikiwi]

Hi,
I have 3 types of packs (FP,WP and GP) that are used in an order processing.
There are multiple deliveries on an order and therefore on each order, there
are instances where any of the paks are used more than once.
What i would like to achieve is for a given order number, I want to sum up
FP, WP, and GP separately regardless of the number of deliveries that were
based on the order...


I tried a crosstab query but that got me into more trouble so I am thinking
doing a DSum on each of the packs, eg:

=DSum("OrderPackQty","tblOrderPack","OrderID = " & Nz([OrderID] AND
??....PackName = FP??,0))

but there could be some other method to get the data I want..
Can someone enlighten me on that?

Thanks

 

[Duane Hookom]

Add text boxes to your Order Header or Footer with control sources like:
=Sum(Abs(PackName ="FP"))
=Sum(Abs(PackName ="WP"))
=Sum(Abs(PackName ="GP"))