To query for records with no values in a particular field, use _____ as the criterion.
A) Is Not Null
B) Is Null
C) Is Blank
D) Zero

Question

Quizplus · Accepted Answer

"Is Null" is the best choice as it specifically checks for fields with no values. "Is Not Null" would return records with data in the field and "Is Blank" may not necessarily pick up on fields with no values (such as fields with spaces or other non-null characters). "Zero" is also not applicable as it only checks for fields with a value of zero.

To Query for Records with No Values in a Particular