Delete data in Column

  • Thread starter Thread starter JB
  • Start date Start date
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
 
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]
 
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.
 
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
 
Back
Top