how to make "update"query?

  • Thread starter Thread starter Fuzuy
  • Start date Start date
F

Fuzuy

I wondered what kind of query I have to use( or what steps or others I
should do) to update a field which not only retain whatever it has
already had and concatenates a new information afterwards if it has
one. Hopefully, it makes sense to you.

Can it be done, if so how to do it? Thanks in advance for help.
 
Set the field to itself, plus what is new:



UPDATE ...
SET fieldName = ( fieldName + ", " ) & newString




where I assumed the field is NULLABLE, type String (varchar), and the
length of the new expression does not exceed the limit of the field (50, or
whatever it is, by design, but cannot exceed 255 char).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top