Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old December 10th, 2015, 12:27 PM
dof2001 dof2001 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2009
Posts: 53 dof2001 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 8 m 26 sec
Reputation Power: 9
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

Reply With Quote
  #2  
Old February 11th, 2016, 02:34 PM
kkmb kkmb is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2016
Posts: 1 kkmb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 26 sec
Reputation Power: 0
What you want to do violates database design principles. You'd rather accomplish that in MS Excel than try to do it in Access.


Thanks,
Kelvin
IT developer

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Combining Data


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap