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.