how can I global delete in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
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]
 
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"," ")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Music STILL will not play! Help! I have little time left! 2
Lost Document "Missing shortcut" 1
Quick/efficient way to VBA subtotal 2
Deleting Rows based on a Value 1
Help getting 2 formulas into one 2
Exclude phrase from email 0
Iteratively delete rows from a spreadsheet 3

Back
Top