Is not Null

[Gismo]

Hi All,
I need to flag a record in a table when one of the text fields are not blank
i used an update query to update active to "True" when the text field = is not null
the query does not recognize the blank field so it flags all the records to "True"
any suggestions please?

 

[GinaWhipp]

The field may not be NULL, it may just be EMPTY which is why Is Not Null is not working. Try using...

<>""

 

[isladogs]

Better still allow for both nulls and empty strings: Nz(FieldName,"")<>"'

 

[Gismo]

Thank you very much for the help, works perfect