Compare tables and delete

[MarcusAntonius]

I have two tables: Table A and Table B. Table B is wiped and reloaded with fresh data every day. The PKey is 'MAC address'.

I'm trying to create a delete query which will compare the two tables and delete any records in Table A that are not found in Table B, but I'm having problems with the syntax and can't get it working. Suggestions/solutions?

 

[Mile-O]

• Use the Find Unmatched Query wizard;
• Reverse the criteria in the new query; and
• Goto Query -> Delete Query to change the query to a delete query.

 

[MarcusAntonius]

When I do that and then run it, I get "specify the table containing the records you want to delete"

I open the query and add the field Table A.*

running that I then get 'could not delete from specified tables'