Add data to the left of existing data in Access

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

Guest

I need to add data to multiple records in specific fields but I need to add
it just to the beginning of the field and keep all the existing data that is
already in the field. I know there must be a simple solution....I just don't
know what it is.
 
Try this SQL UPDATE statement:

UPDATE theTable
SET theField='Newly added data in front of existing' + theField
WHERE <If you need update condition...>
 
Where do you want to do this?

In a Control on a Form? Subform? Query?
 
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

paste data at end in field 8
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Changing existing code to add "IF Statement" 7
importing data in Access (and replacing exisiting data) 2
How to add an additional field in the existing database table 5
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Access Access 2010 import/append data into table w/o overwriting existing records 0

Back
Top