Rows to Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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