Running Sum Criteria
$30-60 USD
Paid on delivery
I need a running sum total to work correctly in my query for Access97. The following is an example of the incorrect total for CustomerID # 111 for my query Invoice# 7441 8037 8038 8277 AmtApplied 21.50 15.50 46.00 99.00 RunningSum 203.50 4550.25 4596.25 4711.50 This is the correct information that is needed Invoice # AmtApplied RunningSum 7441 21.50 21.50 8037 15.50 37.00 8038 46.00 83.00 8277 99.00 182.00 The code is listed below. I know I probably need a nested query but dont know how to write it. SELECT [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [testfordsum].[Total]-[testfordsum].[AmtApplied] AS Balance, [url removed, login to view], [url removed, login to view], [url removed, login to view], DSum("[url removed, login to view]","tblInvoice","Format([url removed, login to view],'yymmdd')&([url removed, login to view]) <=" & Format([tblInvoice].[InvoiceDt],'yymmdd') & ([tblInvoice].[InvoiceID])) AS RunningSum FROM testfordsum ORDER BY [url removed, login to view];
## Deliverables
I need the query to produce the following: a) Able to select invoices by Customer ID and b) The selected invoices to provide a running sum by the AmtApplied field I need a running sum total to work correctly in my query for Access97. I will provide a zip copy of the development database. Anyone who has used Access for several years could probably get this done in a couple of hours if that long. Please email me if there are any questions asap since I need this done very quickly. (within 48 hours)
## Platform
Windows NT Access97
Project ID: #2869036