Recent content by Sebastapol

Thanks all, I tried DISTINCTROW but no joy. IdNumber is the primary key on Table1 but not on Table2 which would have duplicates. So maybe this is the issue. @arnelgp solution works however... Still, it seems odd the select query would pull back results but the delete query did not want to execute

Thanks @arnelgp this works for me. Still not sure why the other syntax wouldn't execute for me though.

I am banging my head against the wall with this one in frustration because the Delete query so simple but it will not execute with the error 'Specify the table containing the records you want to delete' each time I run it. The select query based on the same works fine, but when I switch to a...