Merging truncated data on table

[balllian]

I have got data which has been truncated over severalf fields within one column of my table. Each field which has been truncated has the same reference no for each line of data which has been split up. Is there a way of getting this truncated data back together using access.

For example the data in the third column of my table has been split up into ten rows of info but the the first and seconds columns refer to one reference no.

Thanks in advance...

Ian

 

[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

 

[balllian]

ok i created the function with this code in. Do i need to alter this in anyway to now merge my column togther as im not sure what the next step is.