Can I add text to a memo field

[Robin Chapple]

I have a memo field that carries "Notes" about each member.

At times I need to add the same comment to many members selected by a
criteria in the query. Is it possible to use an update query that will
retain the existing contents and add a common comment to the qualified
records?

Thanks,

Robin

 

[Bob Howard]

I've never done this, but it would seem that if you used some code to fetch
the existing data, add a couple of carriage returns, and then add the new
comments --- it just might work!

A = A + Chr(13) + Chr(13) + B

 

[Ken Snell [MVP]]

UPDATE MyTable
SET MyMemoField = MyMemoField &
" My New Text";

 

[Robin Chapple]

Thanks Ken

 

[Ken Snell [MVP]]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Thanks Ken