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

Try update to Null to put nothing.

"JB" wrote:

> 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 did but now I have Null in the cells instead of No Post


"KARL DEWEY" <(E-Mail Removed)> wrote in message
news:2E8A2677-FAD6-4673-9B14-(E-Mail Removed)...
> Try update to Null to put nothing.
>
> "JB" wrote:
>
>> 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
>>
>>
>>

On Thu, 20 Jul 2006 17:20:07 +0100, "JB" <(E-Mail Removed)>
wrote:

>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]

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.

"JB" wrote:

> I did but now I have Null in the cells instead of No Post
>
>
> "KARL DEWEY" <(E-Mail Removed)> wrote in message
> news:2E8A2677-FAD6-4673-9B14-(E-Mail Removed)...
> > Try update to Null to put nothing.
> >
> > "JB" wrote:
> >
> >> 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
> >>
> >>
> >>
>
>
>

On Thu, 20 Jul 2006 18:29:21 +0100, "JB" <(E-Mail Removed)>
wrote:

>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]

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

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Thu, 20 Jul 2006 17:20:07 +0100, "JB" <(E-Mail Removed)>
> wrote:
>
>>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]