PDA

View Full Version : Search for empty fields .. is it possible?



hardbop-man
12-19-2008, 08:10 AM
I want to search for fields/checkboxes that are empty so that I know where to put my spare time :-)

When I try to use the search function I can't seem to find that function at all ?!? Does OrangeCD lack that (crucial) feature or am I dumb, def and blind?

Jazz_North
12-19-2008, 03:18 PM
Use Advanced Search under Query. If the field is a text field (including date fields) one of the choices in the Condition box is "is empty", which naturally grays out the value field. If it is a checked field, one of the choices is "is not checked". Of course, for a check box, "not checked" may be what you want anyway.

[quote=hardbop-man]I want to search for fields/checkboxes that are empty so that I know where to put my spare time