data in rows to column

[topcat]

I have a table with order data that I need to display as one row for each customer with order description in columns. There are up to 20 different products in the description field, but each customer has at most 3 products.


Table
ID# desc
101 item1
101 item2
101 item3
102 item1
102 item2
103 item1
104 item1

Need to display as:
ID# desc1 desc2 desc3
101 item1 item2 item3
102 item1 item2
103 item1
104 item1

Crosstab queries don't work in this instance. Is there a way to do this in the SQL editor in an Access query? I am using Acess 2007.
Thanks.
T.C.

[alansidman]

this might be helpful

http://www.datapigtechnologies.com/f.../crosstab.html

Alan

[June7]

Options:

20 queries then join them on the common ID field.
DLookup function in expression in query to create fields.
Use VBA.

Review:
https://www.accessforums.net/showthr...719#post105719
http://allenbrowne.com/func-concat.html