NOT NULL

[EscapeUK]

In my select statement how do I check for null values, for example bring back all records where a certain field is not null

 

[Ngolem]

add this to your record select formula

..... and
not isnull(table.value} and
.....

hope this helps
Jim