Sorry about this ..
newbie still learning..
I need to write a query which basically pulls a field called membersid and then test within a field called phototaken a true or false result.
The test is to check if a file exist of the same membersid name. The photos of the member are all jpg. and live in a subdirectory under neath the database location called photos.
How can i do this to check each member and then check if there is a file and then alter the check box to be correct.
Please can you explain everything clearly and do not assume anything of knowledge as I am still learning..
Many thanks ..
Nick
newbie still learning..
I need to write a query which basically pulls a field called membersid and then test within a field called phototaken a true or false result.
The test is to check if a file exist of the same membersid name. The photos of the member are all jpg. and live in a subdirectory under neath the database location called photos.
How can i do this to check each member and then check if there is a file and then alter the check box to be correct.
Please can you explain everything clearly and do not assume anything of knowledge as I am still learning..
Many thanks ..
Nick