Empty fields and using null

[WendyS]

I am creating a report where I want to exclude a group of files with keyword=Fasttrack. I have tried using the selector to hand pick fields where Keyword does not equal Fasttrack.
Unfortunately, this results in a group of records which do not have Fasttrack keywords, but which do have some other keyword BUT records which dont have any keyword at all are excluded.
I have also tried /ifnull (Keyword)/ as a formula and then using the hand picker to select records where this statement is true - that didnt work either.
Im sure there is quite an easy solution to my problem - I hope you can help.

 

[FoxG]

Hi Wendy,

It should work with a record selection formula of ...

if isnull({keyfield} then TRUE
else {keyfield} <> &quot;Fasttrack&quot;

Hth,
Geoff