Hey there...
I've a simple db and need to run a query to check for is null on multiple fields.
Basically I need to include in my report the record if any of these fields are "is null" age, gender, eye, hair
This code only returns value if all criteria are null. I need to check any field for null.
I've a simple db and need to run a query to check for is null on multiple fields.
Basically I need to include in my report the record if any of these fields are "is null" age, gender, eye, hair
This code only returns value if all criteria are null. I need to check any field for null.
Code:
SELECT tblMain.uid, tblMain.age, tblMain.gender, tblMain.hair, tblMain.eye FROM tblMain WHERE (((tblMain.age) Is Null) AND ((tblMain.gender) Is Null) AND ((tblMain.hair) Is Null) AND ((tblMain.eye) Is Null));
Comment