moving data from recordsets to a single memo field

B

Bre-x

Hi,

I have this problem and I hope you guys can help me.

This is how the data is on my table

Table Structure
SO: Number Field
Line: Number Field
Description: Text Field

Actual Table
SO, Line, Description
23, 2, Description 1
23, 3, Description 2
23, 4, Description 3

This is what I want to change it to:

SO: Number Field
Description: Memo Field

SO, Description
23, Description 1, Description 2, Description 3


Thanks for your help

Bre-x
 
Top