Excluding null values from query result (2003)

Topic

New Reply

I am writing a query to exclude null values from a query result but for some reason it keeps bringing up NULL values all the time, see screenshot.
Query:

<"01/11/06" And Is Not Null

Reply | Quote

Replies

See my reply to your other post.

Reply | Quote

Your less then is referencing a string by putting the dates in double quotes. Wouldn’t this give you a type mismatch error or is your date field a text value? If the date field is a text value then you need to convert it to a date value where you can use the less then criteria.

Are you sure the blank is a null value or perhaps it it a space. Retry your query after converting the date column to a date type field.

Reply | Quote

I understand that you will try converting to a date, but also.
Imported data often contains zero length strings in fields that appear empty. So to exclude them you need to test for “”

<"01/11/06" And Is Not Null and “”

Reply | Quote

Thanks for that, that

Reply | Quote