Quote:
Originally Posted by Ronin47
i had messed about with the yes/no/null column but it was giving me problems searching for some reason
|
Yes, a yes/no field can be confusing. It has three values, so searching for false only finds empty, not "No" and searching for true finds yes
and no records. You have to search for "#field:Yes" to find records marked Yes and "not #field:Yes" to find empty and "No" records.