Concatenate into one field

[LICKY]

On the example in your reply here is the SQL (this works);

UPDATE tblPartModel INNER JOIN tblPart ON tblPartModel.PART_NUMBER = tblPart.Part_Number SET tblPart.PartNumber_ProductType = [PartNumber_ProductType] & ", " & [Product_Type];

Notice where the inner join is. It needs a little work to get rid of the first ", ", i.e. use on IIF statement.