Check whether file name exists in Folder & mark Yes or No

[recyan]

Hi,



Let us say, I have a table myTable with a single field, FileName , the values of which are unique.
Eg:
FileName
a.txt
b.txt
c.txt
d.txt
e.txt
f.txt

I have a folder, say myFolder, which contains these files. Some of the files are missing in this folder.
Existing Files in Folder
a.txt
b.txt
f.txt

Missing Files in Folder
c.txt
d.txt
e.txt

I want to run a query, which will give me the below results :

FileName Existing
a.txt Yes
b.txt Yes
c.txt No
d.txt No
e.txt No
f.txt Yes

Is this possible ? If yes, can I request some help.

Thanks

[recyan]

Found this helpful

http://www.access-programmers.co.uk/...d.php?t=136072

Thanks