Can You Update Blank Fields ??

[GBL]

Hi Guys:
Got a database built containing a text-field that has some values in it.
I want to revise the cell-fields that are blank with an update query. The
value I want in the blank cells is "A". I believe the query-field of
"Update to:" should contain "A"; but specifically what should be entered in
the criteria-field?? Every thing I've tried does not want to work.

Thanks in Advance.

 

[Douglas J. Steele]

It depends on whether the fields contain Nulls, contain Null strings or
contain a space.

If they contain Nulls, the criteria should be Is Null

If they contain Null strings, the criteria should be = ""

If they contain a single space, the criteria should be = " "

If you want to catch all of those at once, you can create a calculated field
SearchField: Len(Trim([MyField] & "")) and then use 0 for the criteria.

 

[Wayne Morgan]

The criteria would probably be

Is Null

but may be

""

 

[Evi]

Try typing in:

Is Null Or ""

to catch both blank and Null fields (there is a difference although they
look the same).

Evi

 

[GBL]

Hey Guys; Many thanks!!!

Try typing in:

Is Null Or ""

to catch both blank and Null fields (there is a difference although they
look the same).

Evi

entered