Combining 2 fields into 1

[JJT]

I have a table with about 1000 records. The
record has an Item field, a Code field and an Id field. The Item field in blank but it is a combination of the two other fields.

Is there a query I can use to combine the Code and Item fields and then put the result into the Item field ?

If so, Thanks very much !

 

[cfmiles]

Yes - use an update query. Update the Item field with >>

&[ID]  (type it just like that)

 

[JJT]

It works. Thanks