Selecting records on NULLs 1

[markajem]

V8.5

My mind is just not functioning correctly today.

Trying to create a selection formula that will pull only records based on a NULL value from two different fields in the same record working only with one table.

Example: Pull records that this field GP_Ord is Null or this field RB_ord is Null.

Thanks for your help

 

[lbass]

Use a record selection formula like:

isnull({table.GP_Ord}) or
isnull({table.RB_ord})

-LB

 

[markajem]

Thanks LB. I was trying to advoid using an "OR" in my selection formula. I just don't trust it. But it works though.