Hi,
I was wondering if is possible to add an order count/total weight per day for the query below.
Thanks,
Steve
SELECT T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate, SUM(T1.weight1) 'Weight'
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocDueDate>=[%0] and T0.DocDueDate<=[%1] and T1.whscode LIKE '%[%2]%' and T0.DocStatus = 'C'
GROUP BY T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate,
ORDER BY T0.DocDueDate, T0.DocNum