Listing data rows as coulmns

[casey]

Hello all,

I have a crazy question. Is there a way to write a query that would display data rows with common ID's as if they were columns in a query? It's for visually representing row data as if they were one record in a list. Basically, I would like to take the following data...

fldID fldDetail fldValue
1 Shape Round
1 Color Blue
2 Shape Square
2 Color Red

And display it in a recordsource like each is one record:
ID Shape Color
1 Round Blue
2 Square Red

Is there a way to do this? HTMS.

 

[Jon K]

You can use the Crosstab Query Wizard to build a crosstab query.
.

 

[casey]

I'm unfamiliar with crosstab queries, but I'll check it out. Thanks for the tip.