That¹s pretty much what I realised as soon as I¹d hit send! Thanks.
On 2/7/10 16:00, "Richard S. Russell" <[email protected]> wrote: > > >> 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). > > > > > This email message has been scanned and delivered safely by Mimecast > <http://www.mimecast.co.uk> . > > <BR> @|from|cn|@ @|from|title|@ - @|from|company|@ Tel: @|from|telephonenumber|@ @|from|wwwhomepage|@ @|from|streetaddress|@, @|from|l|@, @|from|st|@, @|from|postalcode|@, @|from|co|@ ----------------------------------------------------------------------------------------------------------------------------------------- Media Square plc or any of its subsidiary companies may not be held responsible for the content of this email as it may reflect the personal view of the sender and not that of the company. Should you receive this email in error, please notify the sender immediately and do not disclose, copy or distribute it. While Media Square plc scans all outbound emails for viruses, it cannot be held responsible for any infected files that you may receive. Media Square plc advises all recipients to virus scan any file attachments. Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered Office: Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ This email message has been scanned and delivered safely by Mimecast. -----------------------------------------------------------------------------------------------------------------------------------------
