Not isnull question 1

[bld21]

I am using crystal 2008. I am trying to exclude all records with null values in the address 3 field below. I am using the formula below. My feeling is that this should work however I am still returning records with null values in the address 3 field. Any ideas?


{S_SRV_REQ.CREATED}>= Date (2010,01,01) and
not isnull({customer_address.addr_3})

Thanks - Bruce

 

[fisheromacse]

Could the data be blank instead of null?

add:
and (not(trim({customer_address.addr_3})="")

and see if it improves your results.

 

[bld21]

Hmm, that makes sense. I forgot the field may contain blank data and assumed that null would catch the blanks.

Thanks!