
December 10th, 2015, 11:27 AM
|
Contributing User
|
|
Join Date: Feb 2009
Posts: 53
Time spent in forums: 12 h 8 m 26 sec
Reputation Power: 10
|
|
Combining Data
Hello,
I am assigned to reduce the size of a table by expanding horizontally:
So i have a list of clients with multiple policies, so instead of having the same client 5 times with each policy it holds i want 1 entry with all the policies, ex:
Initial Table
Code:
CN Order Date Shipping Date Order# Policy Number
AAA 5/5/2015 7/5/2015 100256 A58965
AAA 5/6/2015 7/6/2015 100266 A58966
AAA 5/5/2015 7/6/2015 100266 A58967
AAA 5/6/2015 7/6/2015 100266 A58968
AAA 5/6/2015 7/6/2015 100266 A58969
ABC 7/8/2015 7/10/2015 100998 BX879
ABC 7/9/2015 7/10/2015 100978 BX855
ABC 7/8/2015 7/10/2015 100978 BX251
ABC 7/9/2015 7/9/2015 100978 BX472
And i would like to have something like this:
Final Table
Code:
CN Order Date Shipping Date Order #Policy Number
AAA 5/5/2015, 5/6/2015 7/5/2015, 7/6/2015 100256, 100266 A58965, A58967, A58968, A58969
ABC 7/8/2015, 7/9/2015, 7/9/2015, 7/20/15 100998, 100998 BX855, BX879, BX251, BX472
Is this possible to accomplish in Access, maybe sql code or just a formula, any help will be appreciated.
Thank you
Dof
|