Changing multiple records in a table 1

[jasonsas]

HI,

Hopefully I'm posting in the right forum. I have a field in a table which contains many records. What I'd like to do is change multiple entries from one thing to another Eg, from "Manager - Technical Services" to "Manager, Technical Services".

Is there a quick easy way to do this?

Thanks

 

[ZmrAbdulla]

Use an update query.
see help on this topic heading "Create an update query"

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[abaldwin]

Create a new query and using the sql view in design it would look something like this

Update table1 set jobtitle = 'Manager, Technical Services' WHERE jobtitle - 'Mangager - Technical Services';

This is assuming that the table name is tabel1 and the field you want to change is jobtitle.



Andy Baldwin

 

[PHV]

In a standard code module named, say, Module1, create the following function:

Public Function myReplace(myString, myFind As String, myRepl As String)
If Trim(myString & "") <> "" Then
  myReplace = Replace(myString, myFind, myRepl)
End If
End Function

And now your update query:
UPDATE yourTable
SET yourField = myReplace([yourField], ' - ', ', ')
WHERE yourField Like '* - *'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[willir]

Jason

Eg, from "Manager - Technical Services" to "Manager, Technical Services".

Hind sight...
To maintain consitancy for this type of thing, you may wish to consider adding a support table or tables where the job codes are restricted to a "pick list". A typical approach would be to use a combo or list box to reference the other table.

Richard