Search and replace empty cells

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

HI All

I wonder if someone could help.

I'm using the find and replace dialogue in Access. I've highlighted the
column I want to work on and am trying to find and replace those cells
which are empty with a number. I've tried all sorts of combinations of
wildcard but can't get Access to do it.

I thought "" would work , but find it doesn't. Can anyone help?

Any advice gratefully received.



Best Wishes


Colin
 
HI All

I wonder if someone could help.

I'm using the find and replace dialogue in Access. I've highlighted the
column I want to work on and am trying to find and replace those cells
which are empty with a number. I've tried all sorts of combinations of
wildcard but can't get Access to do it.

I thought "" would work , but find it doesn't. Can anyone help?

Any advice gratefully received.
Click to expand...

Use an Update Query instead, with a criterion of

IS NULL

on the field.

John W. Vinson [MVP]
 
Back
Top