How do I use a query to "add" two text fields together?

[Seth Schrock]

I'm trying to update multiple record all at once using an update query. My problem is that I don't want to erase the text that is already in the field. I'm using a Notes field on a pop-up form and the Update query updates the notes field in the table with what I typed into the notes field on the form for all of the records matching a given criteria. For example, if the field already has "ABC" and I want to update the field of multiple records to have "DEF", then the field will be "ABCDEF" after the update is run.

I looked at the crosstab query, but that looks like it is for numbers and not text. The append query does whole records not just certain fields. What I'm asking might not be possible, but I thought I would ask before I wrote off the possibility.

[Rabbit]

The ampersand (&) is the append operator.

[Seth Schrock]

So in the Update To field of the Update query, I would put "& Notes{field on form}"?

[Rabbit]

An operator requires two inputs. If I wanted to append the string "DEF" to a field called FieldName, I would use
FieldName & "DEF"

[Seth Schrock]

Works perfectly! Thanks.