UPDATE QUERY TO COMBINE 3 ITEMS INTO DATA 1

[MICKI0220]

I need to create and update query that will take the name of a part (itemName) and combine it with two other strings to make a path. I am trying to populate 2000 records with the image path. Therefore I need to combine static ....M:\MF JPG + [ITEMNAME] + .JPG. This will give the full path of the image, the only thing that changes in each record is the [itemname]. I hope I am making sense

Thank you in advance
Micki

 

[Andrzejek]

How about:

UPDATE tblMyTable
SET PathField = 'M:\MF JPG\' & tblMyTable.ITEMNAME & '.JPG'
WHERE....

Have fun.

---- Andy

 

[MICKI0220]

Great, that did it.

Thank you for your quick response.