I have information on a database that has some surnames with "(z)" before their surnam and others without that. I want to remove those incidences of "(z)" so that just the surname is left.Can anyone help me, please?
What sort of database?
Oops sorry it is in Access 2000.
Sort the table in ascending order then all the "z" will or should be at the bottom, then you should be able to delete the "z".Orrun a query to find the data with "z" before it and delete it from there.
Backup your database first so you can't accuse me of wrecking it....If your table is called tab1 and the field is called surname then create a query, go into the SQL editor and type:update tab1 set surname=right(surname,len(surname)-3) where left(surname,3)="(z)"hit the ! button to run the query and hey presto!remember backup first!!!
Can I thank you all for those who have responded to this quiry. I have resolved the problem. Your help is much appreciated.
This thread is now locked and can not be replied to.
Surface Pro (2017) vs Surface Pro 4
20 groundbreaking 3D animation techniques
How to mine Bitcoin on Mac
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.
© Copyright 2017 IDG UK. All Rights Reserved.