Number of shipments per sales order

[AHGepicoradmin (Elise Bumpstead)]

Can someone help me out with how to design a BAQ that tells me the number of shipments per sales order?

[dhewi (Daryl Hewison)]

If you bring the ShipDtl table into a BAQ and display only the OrderNum and PackNum fields, and make both “Group By” fields, you’ll get a list of the combination of both.

If you then make that a Subquery and add a Top Level Query bringing the Subquery into it, you can display only the OrderNum field and make it “Group By” again, which will show each Order once. Adding a Calculated Field with “COUNT(Subquery1.PackNum)” or whatever you’ve called it, will give the number of PackNums per Order.

[AHGepicoradmin (Elise Bumpstead)]

Thanks Daryl
That’s got me exactly where need to be.