updating field

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

Guest

I have some data in a field with text type. I want to update some data in the
field basing on a criteria by adding text to existing field by using update
queries.For example suppose I have "rs" in the field . I want to add "D" to
the field then it becomes "rsD". pl. tell me how to do this? or which
functions should be used in the queries.
 
UPDATE YourTable SET [YourField] = [YourField] & 'D' WHERE YourField =
'YourCondition'
 
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

Access 2010 Reports 0
Data Mismatch in Excel 2010 4
How to validate time format from a text field? 2
Update back-end tables, fields, relationships etc... 6
Updating tables when you input new data 0
Update Query Questions 7
How to subtract a number from a Mergefield? 0
Field types 4

Back
Top