Sorting Data
I have data imported from Excel to Access. The data is simply a record of
transactions. Many payments belong to one account. I need to sort out the accounts with outstanding balance. However, I cannot exclude the "pay in full" transactions to accomplish my purpose because many other partial payment records which belong to the same "pay in full" account will still remain in the sorting outcome. Do I need to have the data of same account merged together? How do I do the merging? Or is there some other ways? Such as I should set up certain kind of table? These data needs to be updated daily from an Excel book. How should I update the data to accomplish my purpose? I will deeply appreciate the help. Thank you, Linda |
Sorting Data
Hi, Linda-
Why not include the "paid in full" transactions? For a given customer if you consider all the charges and all the payments, the paid-in- fulls will simply "wash" (net to a zero sum), and the difference between total charges and total payments is the amount outstanding. I think you'll be doing yourself a favor to include all transactions. And if you ever need to create a statement type of report, you'll have the data on hand already. Just another $0.02~ DaveO Eschew obfuscation |
All times are GMT +1. The time now is 09:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com