April 13, 200520 yr I have a database with a calculated text field that builds a file path, based on information in other fields and adding the suffix ".jpg". There is a calculated container field (that references that text field) to display the jpg image. I would like to make another calculated field that return YES or NO, indicating whether the container field shows an image or whether it displays "THE FILE CANNOT BE FOUND" (due to a misspelling in the jpg file, or simply because it doesn't exist). Is there a function that can do this? Thanks in advance for the help.
Create an account or sign in to comment