Can you please help,
I use below script to get the data from SQL. (I need to do some data comparison)
I need to group it By Reference , Invoice Date.
Please see sample attached. (2 tabs, Original Sheet1, Sheet 2 is how I would Like to see it).
Any help is appreciated.
SQL Script or Excel Macro.
SELECT ISNULL(FO.Reference, '') AS [Reference], FO.SubTotalAmount AS [SubTotAmt], FinalizedOrdersInvoices.In
r AS [InvoiceNumber],
(Select TransactionDate from AROpenTransactions where AROpenTransactions.Transac
r) AS [InvoiceDate]
FROM FinalizedOrders FO
INNER JOIN FinalizedOrdersInvoices ON FinalizedOrdersInvoices.Or
derNo = FO.OrderNo
Where ((FO.AccountNumber in (9500,9600,9601,9602,9603,
10012))) and ((FO.OrderDate >= '2015-01-01') And (FO.OrderDate <='2015-02-28'))