Concatenation to new column

[aburne04]

Hi everyone,

I don't know if anyone can help me, I've been pulling my hair out over this but I think it must be something simple... I'm using MS Access 2003 (v11).

I have a table with a column of model numbers for products. I want to create a query that will take the model number, add .jpg to the end and then create a new column to put the result into.

I've tried a few different things but don't seem to be able to get the data to go into a new column.

I'm using =[pmcode]&".jpg" to join it together, but don't know how to get it to go somewhere!

Regards,

Andrew

[cridley]

why? you should only need the first column, you'd only be replicating data with the 2nd. You can always get the jpg name from the first column by adding '.jpg' in the code...

[chazzy]

UPDATE table SET newcolumn = [pmcode]&".jpg"

no?