update all records with additional text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
Back
Top