I'm making a delete query that doesn't work. I included a picture attached to this post so you can look at it. (It gives me an error, the help suggests it may be read only, but I don't have it set to read only)
Here's what the query is inteneded to do.
I have an OrgChart that lists employees, subsidiaries, and positions they hold.
IE - Me IBM Design
If a person has at least one position at a subsidiary he is specified as a officer, director, or both by the person who enters the data. However, if they delete the record on the orgchart they will still exist on the Employee title table with a officer, director, or both specification. I want this query to seek out and get all the records on the Employee Title table that indicate people who don't hold any positions at the subsidiary. This query does return all those who fit the criteria, but it won't delete them.
Reply With Quote