Is not Null

RunnerDan · Jan 14, 2003

I am trying to write a selection formula that gathers all the items that are not null, or where there is data in a field, any suggestions?

mbarron · Jan 14, 2003

not(isnull({your.field})) fill get you your non-nulls Mike
If you're not part of the solution, you're part of the precipitate.

mbarron · Jan 14, 2003

not(isnull({your.field})) will get you your non-nulls Mike
If you're not part of the solution, you're part of the precipitate.

RunnerDan · Jan 14, 2003

Thanks so much, works great, see what happens when you have a manager trying to do the work of a programmer!