Delete data in Column

[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

 

[Guest]

Try update to Null to put nothing.

 

[JB]

I did but now I have Null in the cells instead of No Post

 

[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?

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]

 

[Guest]

Is it a text field or are you using an option group on your form. If it is
an option group then you need to know what the number or character signifies
'No Post' and use it in your update.

 

[John Vinson]

I did but now I have Null in the cells instead of No Post

That would suggest that you updated to

"Null"

You need to lose the quotes.

John W. Vinson[MVP]

 

[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