Search and replace empty cells

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
 
J

John W. Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open the Find And Replace Dialogue with focus on a specific default column 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Replacing only the empty cells. 3
Search for empty cells and move cells next to 10
Copy and Paste at Access Find and Replace 3
Find and Replace wildcards 2
Find - replace automatic 7
Use of Wildcard characters with replace 2

Top