If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Running Balance
I am using the following query to create running balance at every change of
Invoice Number but no luck, here Invoice Number is a text field SELECT [Inventory Movement Extended].InventoryCode, [Inventory Movement Extended].InvoiceDate, [Inventory Movement Extended].InvoiceNumber, [Inventory Movement Extended].[Company Name], [Inventory Movement Extended].InventoryName, [Inventory Movement Extended].Purchase, [Inventory Movement Extended].Sale, DSum("[Purchase]","Inventory Movement Extended","[InvoiceNumber]='" & [InvoiceNumber] & "'")-DSum("[Sale]","Inventory Movement Extended","[InvoiceNumber]='" & [InvoiceNumber] & "'") AS Balance FROM [Inventory Movement Extended]; any suggestions!!! -- Regards, Abdul Shakeel |
Thread Tools | |
Display Modes | |
|
|