update an existing notes field that already has data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an existing notes field that I want to add more information to it but
when I use the update query it erases the information that is already in
there and puts in the new. Is there anything that I could do differently? Is
this possible?
I probably could make a query and put the two note fields together and then
update it but was looking for a simplier solution.
Thanks for the advice,
Keith
 
To do this, make your update string something like...

=[CurrentNoteFieldName]&[FieldToAdd]

Then update your [CurrentNoteFieldNAme] field with that.

** make a backup of your table first - I have not tested this.
 
Back
Top