Help with crosstab query

[Angel G]

I have a table ORDERS that contains the follwoing:
ORDER LINE PO ITEM QTYSOLD CUSTOMER
I would like to create a crosstab query that returns a single line Number
with the following information (provided that I use an Order number
parameter).
ORDER LINE PO CUSTOMER ITEMS_QTY
The ITEMS_QTY Column needs to contain QTYSOLD and the ITEM separated by a
comma.
Example:
ORDER LINE PO CUSTOMER ITEMS_QTY
MO12159 011 po1213 Mycustomer
10-seat901225,15-tire854623,7-pedal1215,130-rim1514

I have tried many ways but the options I see do not provide what I need.
I welcome any ideas.
Thank you!

 

[John Spencer]

I think you might be able to use the sample concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
to solve your problem.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Angel G]

Awsome! this did it!
Thanks for the link. It is now in my favorites.