It has been awhile since I used a delete query in Access, so I resorted to SQL. Could someone please check my SQL statement, I am getting Syntax errors. I am trying to delete everything in the table US Programming Push that is in the table Barkley Test Stores and Utah
Delete * from [US Programming Push] where (select [Barkley Test Stores and Utah].[Store Number] from [Barkley Test Stores and Utah] join [US Programming Push].[Store Number] on [Barkley Test Stores and Utah].[Store Number]=[US Programming Push].[Store Number]);
Thank You in Advance
Tony