Is not Null (1 Viewer)

G

Gismo

Registered User.

Local time

Today, 22:15

Joined

Jun 12, 2017

Messages

1,298

• Dec 2, 2019

• #1

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

AWF VIP

Local time

Today, 15:15

Joined

Jun 21, 2011

Messages

5,900

• Dec 2, 2019

• #2

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

Code:Copy to clipboard

<>""

 

isladogs

MVP / VIP

Local time

Today, 20:15

Joined

Jan 14, 2017

Messages

18,209

• Dec 2, 2019

• #3

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

 

G

Gismo

Registered User.

Local time

Today, 22:15

Joined

Jun 12, 2017

Messages

1,298

• Dec 2, 2019

• #4

Thank you very much for the help, works perfect