Appending to a data record

[BillA]

I need to do a select query based on a date and then add a note to a field in
the database. In some cases there is already data in the field so I want to
append the data that is there. All I've seen is appending to another table.
So is it possible and do I use an append query to do it?

Thanks in advance for any help
Bill Alsdorf

 

[Daryl S]

BillA -

You can use an update query to update the record, appending new information
into an existing field. In the Update To row of the query for the field you
want to add to, use something like the following:

[field you are updating] & " text you want to add"

or

[field you are updating] & "; " & [other field that contains text you
want to add]