I keep a database of loans issued. Part of our business is to upgrade and consolidate these loans. The database has two basic parts: Loans "upgraded to" and loans "upgraded from". The "upgraded to" table has the new loan number and new loan stats. The "upgrade from" has the old number and stats as well as the "upgraded to" number. For example:
tblUpgraded From:
To: From:
1 11
1 12
1 13
2 21
2 22
3 31
3 32
What I have been asked to do is present this data in a horizontal fashion. Like so:
1 11 12 13
2 21 22
3 31 32
Any suggestions? VBA examples ok.
Thanks!
tblUpgraded From:
To: From:
1 11
1 12
1 13
2 21
2 22
3 31
3 32
What I have been asked to do is present this data in a horizontal fashion. Like so:
1 11 12 13
2 21 22
3 31 32
Any suggestions? VBA examples ok.
Thanks!