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?
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?