Can You Update Blank Fields ??

  • Thread starter Thread starter GBL
  • Start date Start date
G

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.
 
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.
 
Try typing in:

Is Null Or ""

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

Evi
 
Hey Guys; Many thanks!!!

Evi said:
Try typing in:

Is Null Or ""

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

Evi

entered
Click to expand...
 
Back
Top