I am trying to delete records from Table A that don't match records in Table B. I run an unmatched records query from the query wizard to get the results. I then change it to a delete query. It basically shows all records (*) from Table A (delete:from) and the field from Table B as the criteria (delete:where criteria:is null). I am getting the message "Could not delete from specified tables". Does anyone have any hints as to what I'm doing wrong?
Thanks in advance. [sig][/sig]
Thanks in advance. [sig][/sig]