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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update primary key field with multiple "where" clauses 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Combine Fields 5
Sorting misc text into new fields if data exists in record update 2
Update joined tables with info that is currently in Excel? 5
DSum update query with multiple fields 0
Update query & null values 6
edit field data in query 1

Back
Top