Recordset

[buzzboychicago]

Okay...

I need to take a normalized table

ID Item

23 Apples
23 Oranges
23 Bananas
24 Grapes
24 Kiwi


and convert it to

ID Order
23 Apples, Oranges, Bananas
24 Grapes, Kiwi


The "Order" Field being an array with 1 or more items.

Does anyone have any idea of structure or rough thought pattern as to how I would go about this. Someone just said to use a recordset but I am very new at recordsets?

Am I creating a loop? Do I gather the info with a SQL statement?

ANy help is greatly appreciated.

Thanks

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[buzzboychicago]

thats awesome! Thank you!!!

Do you have any idea how I would be able to alter the code to allow for multiple fields?

ie

1 Grapes 2Lbs
1 Walnuts 1Lbs

becomes

1 Grapes.2lbs*Walnuts.1Lbs*

 

[PHV]

No need to alter the code but the SELECT clause you pass as argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886