> On 2/7/10 15:03, "Emma Glaisher" <[email protected]> wrote: > >> Is there any way of finding empty container fields? I’m importing >> batches of images with thumbnails, and sometimes the thumbnail doesn’t get >> picked up and we have to go back and put it in manually. It would be nice to >> isolate the records without thumbnails. But I can’t type = into it!
There may be a more elegant technique, Emma, but I just go with the brute-force approach, namely having ANOTHER field, a calculation, called "Image Exists", with result Number: = If ( IsEmpty ( ContainerField ), "", 1 ) then I format it as a checkbox based on value list "One", which has exactly 1 value in it, the number 1. Search for all the checked boxes, then do a "Show Omitted Only" to find the empty ones (or, if all you ever want is the empty ones, reverse the results of the calculation, call the field "No Image" instead, and find them directly).
