Rows to Columns

[Guest]

I have a query that looks like this:

Customer Order # Item Price
A 100 Blocks $10.00
A 100 Cars $15.00
A 100 Toys $5.00

and I want it to look like this:

Customer Order # Item 1 Price 1 Item 2 Price 2 Item 3
Price 3
A 100 Blocks $10.00 Cars $15.00 Toys
$5.00

Can this be done?

Thanks
c

 

[TPratt]

Yes, use a CrossTab query. The wizard will help you build it.

 

[Duane Hookom]

You can use a report with a multi-column subreport to get it "to look like
this". A crosstab would require much more work since you would need to
define the order/sequence and return multiple values.