Append data

  • Thread starter Thread starter Oyvind
  • Start date Start date
O

Oyvind

I want to append data into a memo field from an another table. The
sourcetable have several records, but the target have only one record. How do
I avoid it to overwrite what already in there. There is a one to many
connection between these tables.
 
Oyvind said:
I want to append data into a memo field from an another table. The
sourcetable have several records, but the target have only one record. How
do
I avoid it to overwrite what already in there. There is a one to many
connection between these tables.
Click to expand...

Hi Oyvind,

With no data nor structure hard to be specific,
but typically the set clause would "reuse" the
"target table" field

SET t1.memofield = t1.memofield & t2.memofield

Unless I misunderstood, that should get all
memo fields from t2 into t1....

of course, as written, they will "run together"

one trick

SET t1.memofield = (t1.memofield + " ") & t2.memofield

good luck,

gary
 
You need to use

Duane Hookom's concatenate function to get the data into a single field and
then add the concatenated data to the memo field

See:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Also you need to have some method to tie the source table records to the
destination (memo) table.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thanks

A lot good stuff here. I managed to fix the problem myself, but thanks to
you both.
Bye the way.... first time I use this website and it seem to be a lot of
good knowledge in here.

John Spencer skrev:
 
Back
Top