Unanswered: Delete query with inner join doesn't work
Please have a look at the attached database. Very simple database: 2 tables. One table (bigtable) contains records, from which a certain number of records need to be deleted. The other table (remove) contains records that need to be removed from bigtable.
I created a query (matchingRecords) that shows which records match between the 2 tables. There are 124 records. These need to be deleted from bigtable.
I created a query (delete_does_not_work), which - you guessed it - doesn't work.
Why does this query not work? I created it with the visual designer of access. If you "preview" the query, it shows the correct 124 records that need to be deleted, but the actual delete doesn't work.
Now, from the research I have done, the query appears not to be "updateable".
How can I write a query that would do this delete. My apologies for this noob questions.