X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Update, Access 2016    
post Jan 15 2020, 01:10 PM

UtterAccess VIP
Posts: 13,585
Joined: 6-June 05
From: Dunbar,Scotland

Hi Everyone

I am carrying out an update of names and have hit a snag.

I have the following string:-

T Onyx, AlTonya Washington

How would I be able to run an update query to Update the string to just this:- AlTonya Washington

I have tried this as the criteria with no success:-

Attached File  Update.PNG ( 3.53K )Number of downloads: 0

Any help appreciated

Hope this helps?


Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
Larry Larsen
post Jan 15 2020, 01:53 PM

UA Editor + Utterly Certified
Posts: 24,410
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)

Hi Mike

That's just one name..??

What ever you use to extract the text value you need from that particular string it will in some way affect other names..

I would look to use the Instr(..) and then use that value in either Left(..) or Right(..) functions..


"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
post Jan 15 2020, 01:58 PM

Posts: 1,153
Joined: 25-January 16
From: The Great Land

What does 'without success' mean - error message, wrong result, nothing happens?

Criteria looks fine to me.

Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th January 2020 - 09:00 PM