Finding .wmf files

[Ron Cates]

Hi All. Wasn't sure where this one should go so sorry if this is the wrong forum.

Here is my problem. I have a database with a container field for each record in a table. The field is meant to hold .jpg files for later export and so on. The images are stored within the file and not just as reference. Today I discovered that one of my users had imported a number of .wmf files in error (my bad for not scripting validation on import although that is what I will be doing while I wait for some assistance). So in order to resolve the problem I need to do a find for all the .wmf files. I have a field that uses GetAsText ( ad ) to display the file name of the image in the container field but on those records with a .wmf file it displays a ? instead of the file name. Records with a .jpg in the container display the filename properly in the get as text field so I know the field is performing as it should but it does not seem to be able to evaluate for the filename of a .wmf file. So now I am left with figuring out a way to find for these files.

The field is meant to only have .jpg files so I am thinking something along the lines of finding for not is empty and ≠ .jpg but I'm not quite sure of the best way to go about this.

Any suggestions would be greatly appreciated.

Thanks

[Ron Cates]

I managed to find and clean out the .wmf files. Now I am having trouble with the calculation for validating the container field. Can anyone help?