Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    4

    Unanswered: Access Update Qry to add 1 character to field

    I need help with an Update query in Access 2003. I have a table with a list of names in one column. I want to update all of them so they all begin with the letter z. This is so I can separate out unused names, adding a z makes them go to the bottom of the list and tells me they are unused. So in my scenario the original list has a name in it like 'ghost story', I want to update that name to be 'zghost story'. I've setup the original table to have a new column for the new name. Can that be done in an Update Query? if so how? Not in SQL please.

    thanks,

  2. #2
    Join Date
    May 2012
    Posts
    4

    Reply to Access Update Qry to Add 1 character

    As always I figured it out on my own. In the Update query, in the Update to field type "z"+[column name]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •