Re: [MS_AccessPros] Changing the contents of a text field

 

Hello Duane . . . took a bit of tinkering but got it to work. Thanks for another save

Steve

On 1/18/2018 10:55 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

 

Hi Steve,

You can use the Replace() function in an update query.

UPDATE [Your Table Name] 

SET [Comment] = REPLACE([Comment],"worked 54 minutes","worked 60 minutes")

I would make a backup of the data first. I typically create a select query first and then change it to an update query:

SELECT [Comment], REPLACE([Comment],"worked 54 minutes","worked 60 minutes") AS AfterComment

FROM [Your Table Name];

Regards,

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Steve thaw5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, January 18, 2018 9:20 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Changing the contents of a text field

 

I have a database of several tens of thousands of records. The database
has a Long Text field named Comment. Several hundred records end with
the phrase "worked 54 minutes of 1 hour allowed". Those several hundred
records need to be changed to read "worked 60 minutes of 1 hour allowed".

It seems to me (a novice) that the thing to do is to use a query to make
the changes. I can write a SELECT query for the records involved. But I
do not know how to write an UPDATE query that changes "54" to "60" while
leaving the rest of the Comment field of the selected records 
unchanged. Advice please?

Or, if a query is not the way to go, what else is there?

Access 2000 file format.

Thank you.

Steve


------------------------------------
Posted by: Steve thaw5 <thaw5@suddenlink.net>
------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.yahoo.com%2Fgroup%2FMS_Access_Professionals%2F&data=02%7C01%7C%7C305dcfddd7cb482de0e508d55e86f7bd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636518856124612867&sdata=DXglWXxiUpkZhbVB4VcoQgotqTK2OGcq4ciXm6Yoxcs%3D&reserved=0

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.yahoo.com%2Fgroup%2FMS_Access_Professionals%2Fjoin&data=02%7C01%7C%7C305dcfddd7cb482de0e508d55e86f7bd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636518856124612867&sdata=gQnu5yVLuUTyJXpNd7lP34yqHSqx%2B4tZFEjBGI2TXgc%3D&reserved=0
    (Yahoo! ID required)

<*> To change settings via email:
    MS_Access_Professionals-digest@yahoogroups.com
    MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.yahoo.com%2Flegal%2Fus%2Fyahoo%2Futos%2Fterms%2F&data=02%7C01%7C%7C305dcfddd7cb482de0e508d55e86f7bd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636518856124612867&sdata=%2BLo1WbLPh54mFIljUzPRyBOVdvMNe6DxK3PwMJcsXrg%3D&reserved=0

__._,_.___

---

Posted by: Steve thaw5 <thaw5@suddenlink.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___