How do you add additional data to existing data? 2

[RonQA]

How do you add additional data to existing data without wiping out the original data?

If I had 20 records and I had a field call datesm which was a list of date and wanted to add another date to all 20 records, what is the proper way to do it?

1/1/2009, 1/1/2010 so how would a create a query to add 1/1/2011? to result in 1/1/2009, 1/1/2010, 1/1/2011

Thanks,

 

[SkipVought]

Hi,

If you have a field named datesm, that contains your dates, then just add another row, which I assume would be row 21 for the new date.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Golom]

Skip
It's not really clear but he may want to add another date column to his table (ref: "... add another date to all 20 records ...")

Probably needs some further definition.

 

[RonQA]

Thanks for the response...

What I am trying to do is to take Column "datesm" that has 20 records and that has the text "1/1/2009, 1/1/2010" in each of the records and add ", 1/1/2011" to all 20 records which would have the final result of "1/1/2009, 1/1/2010, 1/1/2011"

Thanks again

 

[Golom]

OK

UPDATE SomeTable 

SET datesm = datesm & ", 1/1/2011"

Just as an aside, datesm appears to be a multi-valued field and that can cause problems when attempting to use some SQL constructs.

 

[RonQA]

Thanks..got it now..