I created a database to visually compare pictures stored on a computer then delete the duplicate pictures from the computer. I imported the pictures into the Pictures table which has an ID field, an attachment field, and a hyperlink field containing the file location of the picture. After comparing the pictures, if they are the same, I append the picture to a table called DuplicatePictures which only has the ID and file path. The problem is that I want to delete these records from the Pictures table. I created a query in design view, here is the SQL for the query.
The brackets aren't working on my phone so I will use \ for open bracket and / for close
- DELETE Pictures.ID, Pictures.*
-
FROM Pictures, DuplicatePictures
-
WHERE (((Pictures.ID)=\DuplicatePictures/!\ID/));
When I try to run the query, i get a 3086 error