Hi,
I am trying to delete records from my history table (TBL A) if value in my list table (TBL B) has been met but I get a "Could not delete from specified tables" error.. below is my code.
I am trying to delete records from my history table (TBL A) if value in my list table (TBL B) has been met but I get a "Could not delete from specified tables" error.. below is my code.
Code:
DELETE [Aircraft List].Active, [SB-AD History].*
FROM [SB-AD History] INNER JOIN [Aircraft List]
ON [SB-AD History].[Aircraft Registration] = [Aircraft List].[Aircraft Registration]
WHERE ((([Aircraft List].Active)=False));