Sorting Data

[Guest]

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

 

[Dave O]

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