finding rows with a NULL value?

[tutuster]

I need to find the rows from a table, where a certain data has no value, aka null. I've tried to use the isNull({TABLE.DATA}) in my formula but i get dll-error etc.

So, could someone give a pointer on how to create a formula for example:
- TABLE.DATA = 100
- TABLE.DATA2 = NULL

Version 8.5

 

[Madawc]

Try something like

{TABLE.DATA} = 100 
AND IsNull({ TABLE.DATA2})

This would return true or false and could be used in record selection.

Note that if a field can be null, you must put the Isnull test first. Otherwise the formula will stop and return nothing when it hits a null value.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10