I have a column which contains building numbers.

However a number of cells within the columns have had a 0 entered where the
information had been unknown.

However the cells with 0 need to be blank.

i.e how do I alter cells containing 0 and change them into a blank cell?

Thanks for any help

You'll need to do an update query. If you are using the Access query
builder, type the word "Null" (without quotes) into the Update To field.
Don't forget to put zero in the condition field, otherwise you will replace
all values.




"Mark909" <(E-Mail Removed)> wrote in message
news:C7F9C511-8B3A-483C-8778-(E-Mail Removed)...
>I have a column which contains building numbers.
>
> However a number of cells within the columns have had a 0 entered where
> the
> information had been unknown.
>
> However the cells with 0 need to be blank.
>
> i.e how do I alter cells containing 0 and change them into a blank cell?
>
> Thanks for any help