how can I global delete in Access 2000?

J

John Vinson

I am trying to delete the same phrase "w/vocals" in 50,000 rows.
Click to expand...

Without knowing what you want it deleted FROM, or how your table is
structured, all I can suggest is "use an appropriate update query".

Are you trying to delete every record containing this value?
Or are you trying to update each record so that the field containing
"w/vocals" becomes blank?
Or are you trying to edit a field which might contain the text string
"w/vocals" somewhere in it to remove that string?

John W. Vinson[MVP]
 
K

KARL DEWEY

Create an update query and use this as the Update To --
Replace([YourFieldName],"w/vocals","")
or ir you want a space --
Replace([YourFieldName],"w/vocals"," ")
 
Top