if your field can contain values:
enter find mode
create new record / request
perform find and you will be in a set that has only 0 or only 1.
Reverse the found set and your in all records that do not have only 0 or only 1. Probably easier ways to do this using find mode..
You could also put in a calculated field that does PatternCount ( the_field ; "0¶1") > 0
Or find "==1", then Constrain the find for "==2"?
The way to do an "AND" find in a single field is to enter mulitple values space separated
It will use the "begins with", so if you have a field with
These will be found.
Try the space and see if it AND's your search. Or use the constrain, above.
Thanks for your first suggestion, coherentkris, but that didn't work. The found set included both values. The omitted set included only empty fields.
On to try your second suggestion.
Beverly- your second suggestion did the trick.
Your first suggestion almost worked. It needed another Constrain Found Set for ==1 to isolate the two-valued fields.