How can show all [Not] Empty values in a Column ?
Somthing Like : = Nil or IS NIL
and otherwise : <> Nil or is not Nil
Filter Bar Filter Bar : Filter Expression
Re: Filter Bar Filter Bar : Filter Expression
Realy ?
Nobody ?
Isn't it the most usefull filter Expression at all ?
or is it so easy that noboby had a similar problem ?
Nobody ?
Isn't it the most usefull filter Expression at all ?
or is it so easy that noboby had a similar problem ?
Re: Filter Bar Filter Bar : Filter Expression
Hi,
To show all rows with existing column values, you can use the following filter entry: "[field] = NULL" (or "[field] IS NULL"), and to show rows with empty values: [field] <> NULL" (or "[field] IS NOT NULL")
To show all rows with existing column values, you can use the following filter entry: "[field] = NULL" (or "[field] IS NULL"), and to show rows with empty values: [field] <> NULL" (or "[field] IS NOT NULL")