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>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
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.
.
__,_._,___
Tidak ada komentar:
Posting Komentar