update all records with additional text

J

johnny vino

I have several thousand records that I need to add text before and after to
help create bar codes. How do I use update query to do this?
 
R

rpurosky

If the before and after text is the same, it's easy. I will use the example
that "00" has to be the prefix and "H" has to be added to the end (more
specifics from your question would have helped).

In the Update query, add only the field you need to update. My example:
[BarCode]
The Update To line would read: "00" & [BarCode] & "H"
 
Top