Script or calculation to verify status of container field.
I have a database that displays images that are in a folder. The problem is if the file is missing or if the file is corrupt there is a text message in the container field explaining why the image can not be displayed.
Is there anyway to get this text message out of the container field and into a field I can search on?
The container says "The file cannot be displayed:" is the file is corrupt or damaged and " The file cannot be found:" if the file is missing.
I really need to be able to find all the "The file cannot be displayed:" and " The file cannot be found:" records so I know how many there are of each.
there are anywhere from 75k to 290k records and paging through them is not really an option. :)