AnsweredAssumed Answered

How do I filter records based on two fields contents?

Question asked by basilisk2 on Aug 14, 2010
Latest reply on Aug 14, 2010 by LaRetta_1

Title

How do I filter records based on two fields contents?

Post

I want to Find those records that have any content in one field (a text field), and that have no content in another (a text field formatted as a Checkbox with possible entries of Yes or nothing - ie, just one box). This will be part of a script, following on from the "Browse" command.

I have tried using * to denote "any" but the find results in some fields that are blank, while I cannot search for records that "do not include" a specific entry. I also can't find records based on a cross or no cross in the checkbox.

Where am I going wrong?

TIA

Outcomes