When I try to run a delete query, I get the "Could not delete from specified tables" error. The query compares a table ("Pending Memberships") to a union query ("Current Members...") and aims to delete records from the table, not the union query. I imagine it's the union query that's screwing things up since the delete query used to compare one table to another, and since I threw the union query into the mix it's stopped working. Can a delete query not involve a union query at all? If no, is there a workaround? If so, can anyone figure out what's wrong with my current delete query? Code:
Code:
DELETE DISTINCTROW [Pending Memberships].*, [Current Members (Aggregate incl 60 day expired)].First_Name, [Current Members (Aggregate incl 60 day expired)].Last_Name, [Current Members (Aggregate incl 60 day expired)].Mailingadd1, [Current Members (Aggregate incl 60 day expired)].MailingState, [Current Members (Aggregate incl 60 day expired)].Expiration_Date
FROM [Pending Memberships] INNER JOIN [Current Members (Aggregate incl 60 day expired)] ON ([Pending Memberships].MailingState = [Current Members (Aggregate incl 60 day expired)].MailingState) AND ([Pending Memberships].Mailingadd1 = [Current Members (Aggregate incl 60 day expired)].Mailingadd1) AND ([Pending Memberships].Last_Name = [Current Members (Aggregate incl 60 day expired)].Last_Name) AND ([Pending Memberships].First_Name = [Current Members (Aggregate incl 60 day expired)].First_Name)
WHERE ((([Current Members (Aggregate incl 60 day expired)].Expiration_Date) Like "*2013"));
Thanks in advance for any help.