Combine Two Records into One from One Table

[darcien]

Hi, I am trying to combine several records from ONE linked table into one record that have the same Order#.



My structure is as follows:
O5ORD ODTEXT
7788559 OPTIONS END
7788559 OPTIONS BEGIN
7788559 18 4 GW 4 X 10 AIR TIRE
806860 REF 3501050202020
806860 OPTIONS BEGIN
806860 NO

I want it to look like this:
O5ORD ODTEXT
7788559 OPTIONS END OPTIONS BEGIN 18 4 GW 4 X 10 AIR TIRE
806860 REF 3501050202020 OPTIONS BEGIN NO

I am not that familiar with VBA, but I think it can be used to do this. I have searched, but I could not make any of the code I found work. Most of the code I found was based on two tables with a one to many relationship. My data is all in one table, so I kept getting errors.

Can someone please help?

Thank you!

[pbaldy]

Did you try something like this?

http://allenbrowne.com/func-concat.html

[darcien]

Yes, but I do not understand the code enough to change it to my needs. I kept getting erros when trying to use it. I believe it is for 2 tables with a 1:M relationship, where I just have 1 table.

[pbaldy]

What is your code? How are you using it? What errors do you get?