Thanks, just tried it but got the same results. Please see example below;

ACCNO1CATNO11.0000009/09/2008 00:00:00

ACCNO1CATNO11.0000002/12/2008 00:00:00

ACCNO1 CATNO11.0000006/04/2009 00:00:00

ACCNO1 CATNO12.0000008/06/2009 00:00:00

Ideally i'd like to see

ACCNO1 CATNO1 5.00000 ...

Hi Nate,

sorry but I'm pretty new to T-SQL, you mean like this?

SELECT LEFT(SLCustomerAccount.CustomerAccountNumber, 4) AS [Account No], SOPOrderReturnLine.ItemCode,

SUM(SOPInvoiceCreditLine.InvoiceCreditQuantity) AS Expr2, SOPInvoiceCredit.DocumentDate AS Expr1

FROM SLCustomerAccount INNER JOIN

SOPInvoiceCredit ON SLCustomerAccount.SLCustomerAccountID =...