Combine many rows to one row?

Dear friends,

I have a problem that need some help from expert.Is there any way I could combine many rows into a row in Access using Visual Basic. I want to change the below table from TABLE A to TABLE B

TABLE A SampleCode Test Name Result ID Name Sex 9300105Peripheral Blood Film....
a few poikilocytes are present.S7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
No blast cells seen.S7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
microcytes, elongated cells andS7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
hypochromic but normocytic: . SomeS7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
Majority of rbcs appear slightlyS7585512EDHANDAPANI MAHESHM

Output:

TABLE B SampleCode Test Name Result ID Name Sex 9300105Peripheral Blood Film....
a few poikilocytes are present, No blast cells seen.microcytes, elongated cells and hypochromic but normocytic. Some Majority of rbcs appear slightlyS7585512EDHANDAPANI MAHESHM

Your help would be greatly appreciated

Thanks a lot,

Chicky

---

Chicky

You might want to give this thread from yesterday a look:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1335992&SiteID=1

COM conflict resolver EXPERT idea needed(urgent)

Hi,
In COM conflict resolver, let's say, subscriber tries to upload an
INSERTED row to the publisher. By setting
rct = REPOLEAllChanges
in the IVBCustomResolver_GetHandledStates COM function I can catch all
the changes not only conflicts.
And in IVBCustomResolver_Reconcile function of the COM resolver, I
want to manipulate the INSERTED row from the source and eventually
insert that manipulated row to the destination. I tried
rrc.InsertRow
rrc.CopyRowFromSource
rrc.UpdateRow
but they did not work.
What is missing? What should I do to get an inserted row(Not updated
one, update works without any problem) from source in COM resolver
and manipulate it and INSERT it to the destination.
Any help would be greatly appreciated.
Thanks,
Nury SWORD
I found it, and would like to share it with the ones working on COM
conflict resolver before they suffer like me.
In COM conflict resolver, InsertRow is almost useless, it does not do
anything at all.
In Reconcile method, let's say a row is inserted from source to
destination, and you want to manipulate the inserted data row and
INSERT that manipulated row to the destination. In order to do that,
the sequence is :
SetColumn ...
SetColumn ...
...
(you manipulate as much columns as you want with SetColumn)
and then the magical ;
CopyRowFromSource method should be invoked. This is not documented in
anywhere, and I am happy to announce that.. I hope Microsoft includes
a little bit documentation about;
HOW TO MANIPULATE an INSERTED ROW (updated row is given as VB sample)
in COM Conflict resolver...
I hope that helps..
Nury Sword (MCDBA - MCSD)
Toronto
nurysword@.hotmail.com