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

Home Posts Topics Members FAQ

Single column multiple rows to multiple columns single row

2 New Member
I would like this:

ID Field Qualities Field
1 Q1
1 Q2
1 Q3...
2 Q1
2 Q2...
... ...

To look like:

ID Field Quality 1 Quality 2 Quality 3...
1 Q1 Q2 Q3
2 Q1 Q2 ...
...
Dec 5 '13 #1
3 2811
zmbd
5,501 Recognized Expert Moderator Expert
this is a common request, see if this helps:
http://bytes.com/topic/access/answer...le-ids-columns
Dec 5 '13 #2
moosepie
2 New Member
The problem I'm having is that I have many duplicate instances (rows) with the same ID (up to 10 per ID, but not always 10) each with a unique "Quality". I would like each "Quality" to be listed in its own field/column for each unique ID.

Starting with:

IDField......QualitiesField
ID1Data......Quality1Data
ID1Data......Quality2Data
ID1Data......Quality3Data

Ending with:
IDField......Quality1Field......Quality2Field..... up to 10
ID1Data......Quality1Data.......Quality2Data...... up to 10
ID2Data......Quality1Data.......Quality2Data......

I've figured out a non-scalable way to do it in Excel, but my update process is run in Access and my data set will get too large to do in Excel.
Dec 5 '13 #3
zmbd
5,501 Recognized Expert Moderator Expert
Please go the allen browne website that I linked you to in the other thread, it will help you... it has an example that mirrors your need to a "T"

It's a cross tab query
It will group your ID#Data

It will help...

-z
Dec 5 '13 #4

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

Similar topics

1
26455
by: Tuhin Kumar | last post by:
Hi, I would like to know how to insert multiple rows into a table, using a single INSERT statement. My requirement is like this I have a table ABC which contains multiple employees entries with...
1
9714
by: Valerie | last post by:
Hi everyone, I really appreciate if anyone could help me with this tricky problem that I'm having. I'm looking for a sample script to combine data in multiple rows into one row. I'm using...
3
16303
by: JB | last post by:
To anyone that is able to help.... What I am trying to do is this. I have two tables (Orders, and OrderDetails), and my question is on the order details. I would like to set up a stored...
0
1880
by: craftit | last post by:
hi everyone, i need to insert multiple rows in a single table using Oledbdataadapter for access database all in one trip in my winform(VB.Net). i've tried the best i can.Can anyone please help me...
7
43123
by: Mintyman | last post by:
Hi, I'm working on a system migration and I need to combine data from multiple rows (with the same ID) into one comma separated string. This is how the data is at the moment: Company_ID ...
3
28072
Atli
by: Atli | last post by:
Hi. I've been trying to insert multiple rows into a table using a single INSERT statement in MSSQL / SQL Server 2005. I could of course cheat and have my C# code insert each row using some sort...
4
2171
by: erp23 | last post by:
This might seem like a problem with a simple solution, but I'm not entirely sure how to approach it. I would like to generate a user contact list from a table of user details on a database....
2
2980
by: eaocomp | last post by:
How do I display multiple rows in a single column within the SQL Server 2005? Sample Data ----------------------------------------------------- Cust Name Cust_Order...
10
18387
sumittyagi
by: sumittyagi | last post by:
Hi All, Is it possible in oracle to insert multiple rows in a single insert query, as is possible in sql server: insert into test_table values ('abc', 'xyz'), ('mno', 'pqr'); This syntax...
0
1366
by: madhanmss | last post by:
Hi, How to freeze multiple rows and columns in a datagrid. It should be like an excel sheet, if you scroll horizontally, columns should be freezed and if u scroll vertically, rows should be...
0
7231
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
7132
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
7336
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
5640
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,...
1
5059
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4720
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
3211
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
3196
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1568
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 ...

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.