SELECT DistributorPoNumber, OrderNumber, Orderdate, InvoiceNumber, InvoiceDate, SUM(Quantity) Quantity, SUM(NetWeight) NetWeight, SUM(LineNetAmount) LineNetAmount FROM qcf_orderDetail GROUP BY DistributorPoNumber, OrderNumber, Orderdate, InvoiceNumber, InvoiceDate ORDER BY Orderdate DESC, OrderNumber

Order Date	PO Number	Cases	Net Weight	Dollars
#DateFormat(Orderdate, "mmm-dd-yyyy")#	#DistributorPoNumber#	#Quantity#	#NetWeight#	#LineNetAmount#
No order history records found.