1) It is not considered best practice to store multiple values within a single field. Instead, one should create a normalized database structure.
>> Database Normalization and Table Structures.
2)However, there are legitimate instances where one may need to append values to the current value in a field.
Generic for a static value:
-
UPDATE [TableName]
-
SET [FieldName]=[FieldName]+'appendedvalue'
-
WHERE (criteria);
One can get fancier using SELECT and Sub queries to build the final string between tables and then update the third. Once again, if one is needing to do this then it
generally indicates a flaw in the original table structures and relationships. ((I say
generally because there are times where one needs to de-normalize for reports or other specialized situations. Even then I tend to use a VBA function such as this one
Function fConcatChild to build the string on the fly from the normalized data. ))
On a side note:
To store data/information:
Excel/spreadsheets use "Cells"
Access/databases use Tables>Records>
Fields. :)