Microsoft access: query with Null

Question

Hi, I am creating a Microsoft access query. I wish to filter 2 columns.

1st column: I want it to return rows that are null. I have indicated “=is null” under the criteria section but my entire data sheet page returns empty even though there are rows that are null for 1st column.

2nd column: I want it to return rows that only consist of numbers as this field contains both numbers and alphabets.

What would be the criteria/formula I can input for both columns in my query design?

Thanks in advance!

Answer 1

IsNumeric("2lash123")

returns False, so such values will be filtered out.

So, you must do something, that you don't tell about ...