R
RSunday
I have a table T1 with a key-field.
I also have a query Q1 with the same key-field. Q1 is not based on T1, but
some other tables and queries.
Now I want to delete all records in T1 that are not in Q1.
I can make an unmatched quesry finding the records to delete in T1 - but I
fail to turn it into a delete-query.
Please help.
I also have a query Q1 with the same key-field. Q1 is not based on T1, but
some other tables and queries.
Now I want to delete all records in T1 that are not in Q1.
I can make an unmatched quesry finding the records to delete in T1 - but I
fail to turn it into a delete-query.
Please help.