473,508 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Another row value to columns question

48 New Member
Hello!

I have an access table filled with 10k records that look like this:

Product Car
601945 Vauxhall Astra
602117 Peugeot 806
602117 Peugeot Expert
602117 Citroen Dispatch
602227 Vauxhall Vectra B
602227 Opel Vectra B

I want it to look like this:
Product Car
601945 Vauxhall Astra
602117 Peugeot 806, Peugeot Expert, Citroen Dispatch
602227 Vauxhall Vectra B, Opel Vectra B

So putting the car models in one comma seperated column for each productcode that is the same. Now I have seen a lot of posts like this but I can't find the solution. Can you help me please?

Thanks! Sander
Nov 18 '15 #1
1 782
NeoPa
32,557 Recognized Expert Moderator MVP
Hi Sander.

Please let me start by saying that what you propose is a very bad idea indeed. This leads you towards a way of storing data that will be clumsy and very difficult to work with. On the other hand, displaying the data that way, just as one might in MS Excel, may well be very reasonable. For more on this see Database Normalisation and Table Structures.

The link (Listing Items Within GROUP BY Set) will help you to form a query that handles providing data in the format requested. You can use the concept to display or export the data, just as you can to save it and store it. I strongly recommend you avoid doing the latter but I'll leave it with you anyway.
Nov 18 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1534
by: Robin Munn | last post by:
OK, here's another software design question, one that's been bugging me for a while now. What do y'all think is the best way to handle program-level globals, such as configuration option --...
4
1707
by: cwhite | last post by:
Hi I have another drop list question. I have a table like this: computer dell computer ibm computer hp
74
4994
by: Michael | last post by:
As if we needed another string reversal question. I have a problem with the following code, that I believe should work. int StringReverse(char* psz) { char *p = psz; char *q = psz +...
1
1660
by: Krissy | last post by:
When I create a DTS to export a text file from a table, if I click on the Define Columns button and then Populate from source, then execute, it changes one of the types to not quotable and the size...
11
6887
by: Sweety | last post by:
hello to all members, i have strange question in C. main() { printf("%d",main) ; } here o/p is same for all m/c in TC++ version 3.0 i.e 657. I think this is not garbage.
5
1513
by: WebBuilder451 | last post by:
how can i get the value from a specific column from the selected row of a datagrid in the sub i can get the datakey for item command Me.dgMems.DataKeys(e.Item.ItemIndex) will get me the key...
0
722
by: BStone | last post by:
Hi Everyone I posted this question in .Net General too, so please forgive me for posting in two boards, but I saw one reply that indicated I might have better luck finding some help here Using...
6
1638
by: Michael | last post by:
How can I get X (or another value) from this string "asdfsadfX", basically i want to get what ever is in between the tags and place them in a variable called $www , can anyone help?
1
1479
by: TeknoShock | last post by:
I am trying to use an if then in javascript to change one value based on what a user inputs for another value. It is not working correctly. Here is the relevant code: ---------------------------...
9
1686
by: beginner | last post by:
Hi, I run into another C API question. What is the simplest way to convert an PyObject into a double? For example, I have PyObject *obj; I know obj is a number, but I do not know the...
0
7225
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7124
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7385
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5629
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4707
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3195
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1558
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
418
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.