Hello,
i have Two query 1st "Ledger Purchase Query Final" 2nd "Ledger Payment Query"
i have union query Name Ledger
SELECT [InvoiceID] AS [TransactionID], [SupplierName], [InvoiceDate] AS [TransactionDate], [Item Name] AS [Description], [Sub Total] AS [Debit], 0 AS [Credit] FROM [Ledger Purchase Query Final]
UNION SELECT [VoucherID], [SupplierName], [InvoiceDate], [Description], 0 AS [Debit], Format([Amount], "Currency") AS [Credit] FROM [Ledger Payment Query]
ORDER BY [TransactionDate];
How can i get opening balance at specific date with runningsum
like this,
TransactionID TransactionDate SupplierName Description Debit Credit Balance Opening Balance 5000 1 11-03-2015 ABC Receive material 10000 0 15000 2 11-03-2015 ABC Paid Cash 0 8000 7000 3 12-03-2015 ABC Receive Material 4000 0 11000
Attached required database table and queries
please help me...