View Full Version : Combining 2 fields into 1


JJT
10-24-2001, 05:16 AM
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
10-24-2001, 05:29 AM
Yes - use an update query. Update the Item field with >> [Code]&[ID] (type it just like that)

JJT
10-24-2001, 06:15 AM
It works. Thanks