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
 
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 query vs make query 5
Update query 4
adding a Carriage Return or Line Feed character to an update query 2
updatable query 2
Passing Multi-Select to a Query 2
How to update data in a query 1
Update Query using Table & Query 3
Make a change to an Update Query 1

Back
Top