Question

Trevor is working with his data records for paydays. Some of the dates were left blank because of holidays. To find these records with empty fields, what should Trevor type under “criteria”?

is null
equals holiday
>0
<0

Answer 1

null

Step-by-step explanation:

In search criteria, null means blank or empty.

Equals holiday will return all data where entered as holiday.

>0 returns all numbers greater than zero, or any data with length greater than zero depending on your search query. <0 is the opposite.