A
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!
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!