Delete data in Column

J

JB

Hello.
In this db someone has typed 'No Post' in around 350 records in the Address
column (instead of ticking the 'No Post' option)
I've run a query to select where is says 'No Post' and then an update to
try and delete but it won't accept nothing in the 'update to' box.
How can I delete this?
Thank you
J
 
J

John Vinson

I've run a query to select where is says 'No Post' and then an update to
try and delete but it won't accept nothing in the 'update to' box.
How can I delete this?
Click to expand...

Put the word

NULL

with no quotes, no punctuation, just the word, in the UpdateTo row.

Be sure to put

"No Post"

in the Criteria line so you update only these bad records; you should
probably back up your database first just in case!

John W. Vinson[MVP]
 
J

John Vinson

I did but now I have Null in the cells instead of No Post
Click to expand...

That would suggest that you updated to

"Null"

You need to lose the quotes.

John W. Vinson[MVP]
 
J

JN

I did, I put Null no quotes, nothing but it changed everything to the word
Null.
What I did do in the end was Find and Replace, i.e . Find 'No Post' ,
Replace (nothing) and that did the trick
Thanks for your time anyhow
J
 
Top