Crosstab Query help

[aarellano]

I have a table that contains month, partnum, qty, price

month	item	          qty	Price
Jun	6072           	219200	0.541
Jul	6072           	65600	0.789
Aug	6072           	63900	0.789
Sep	6072           	39900	0.789

what I am trying to acomplish is to do this

Item Jun Qty Price  Jul  Qty Price  Aug Qty Price Sep Qty Pr

I tried to do a crosstab in access but I got multiple lines because of the qty.


help please!!

 

[PHV]

Have a look here:
faq701-4524

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aarellano]

wo

http://www that

is a bit confusing!!! but I will give it a try

 

[dhookom]

If you can't figure this out, come back with your exact table and field names.

Duane
Hook'D on Access
MS Access MVP