I'm trying to run a querry to show data when a filed has info in it (Not Null) and do not show when the field is empty.
When I set the query to where `RefNo` is Not NULL - it shows all fields, even though one field is empty. When setting to is NULL, it shows no fields, instead of the empty field. Where am I going wrong?
Further, is it possible to set it on the specific field's custom code (and how). As I experienced the hard way, if you change the edit SQL query page - step 4 - you loose ALL manual formatting on the Visual editor's page, losing hours of work.