Single column multiple rows to multiple columns single row

[moosepie]

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 ...
...

[zmbd]

this is a common request, see if this helps:

http://bytes.com/topic/access/answers/953347-lookup-table-ids-columns

[moosepie]

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......Qu alitiesField
ID1Data......Qu ality1Data
ID1Data......Qu ality2Data
ID1Data......Qu ality3Data

Ending with:
IDField......Qu ality1Field.... ..Quality2Field .....up to 10
ID1Data......Qu ality1Data..... ..Quality2Data. .....up to 10
ID2Data......Qu ality1Data..... ..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.

[zmbd]

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