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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Record Performance - Query vs Code 1
Access 2000 append unbound text box values to a table 0
Compare capitals with non-capitals 7
Count text values in a Access Field 0
Multiplication Expression for Access 2003 Update Query 3
Search for Multiple * Literals 1
Seriously, I need ideas. Fields not transferring from table to table 3
Add record to a table 2

Back
Top