Greetings!
I have failed to generate working queries designed to isolate records with certain fields blank or null. In my case I have three True/False fields and need to isolate records where all three fields are empty. Whether using ‘IS NULL’ operator or whether checking that the fields are neither ‘True’ nor ‘False’, whatever valid query I construct returns zero records (and I know there are such records of course).
I see in the old KEXI forum that there was discussion on this topic during August 2012 between Kexian and J. Staniek. It appears that the suggestion to file a bug was not followed - at least I cannot find it.
I will continue looking at this, but if the earlier discussion is still valid then I can file a bug.
Best. Ian.