fields to columns

[Aron]

i have a list in a table of lots of products with several price types
like this (example)

SKU PriceType Price
1234 Catalog $10.49
1234 Cost $5.19
1234 Sale $9.19
1234 OffSeason $8.49
1234 Wholesale $6.49
5678 Catalog $26.18
5678 Cost $13.46
5678 Sale $23.06
5678 OffSeason $21.38
5678 Wholesale $16.58
6789 Catalog $6.14
6789 Cost $4.17
6789 Sale $5.65
6789 OffSeason $5.39
6789 Wholesale $4.65

i want to make a query and the results should be like this

SKU Catalog Cost Sale OffSeason Wholesale
1234 $10.49 $5.19 $9.19 $8.49 $6.49
5678 $26.18 $13.46 $23.06 $21.38 $16.58
6789 $6.14 $4.17 $5.65 $5.39 $4.65

how can i do this (im having a lot products (50-60 thousand) in the table i
cant do it manualy

Thanks a million

 

[scubadiver]

I would thought a cross-tab query would work. What is the SKU?