Find/Replace an empty field

[James Ivey]

In the Find & Replace thingy, is there a way to Find an empty field?

I want to search my "Country" field, and on any record that has this field
empty, I want to replace it with "United States"

Doable?

James

 

[Guest]

Create a query on the table where the data is stored. In the criteria for
Country write "Is Null". check to make sure that this query brings up all the
records with an empty Country field. Now on the Query menu change the query
type to 'update query'. you will now get another row appear in your grid.
Saying 'Update To' in this box for coutry write United States. Simply run the
query and its all done.

This is all assuming you build your query in the design grid

 

[James Ivey]

Sweet! Works like a charm.

Thanks Falty

Create a query on the table where the data is stored. In the criteria for
Country write "Is Null". check to make sure that this query brings up all
the
records with an empty Country field. Now on the Query menu change the
query
type to 'update query'. you will now get another row appear in your grid.
Saying 'Update To' in this box for coutry write United States. Simply run
the
query and its all done.

This is all assuming you build your query in the design grid