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