Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data | Excel Worksheet Functions | |||
Sorting data within the same row. | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
Sorting Data | New Users to Excel | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel |