Dear Forumers,
Thank you for the help previously on my query. Appreciate it!
I ran into a bit of a problem with deletes.
Suppose I have an Access table, called sheet1. I have two queries, query1 and query2, that selects specific records from sheet1.
Suppose I want to delete all records found via query1 and query2 from sheet1. How can I do it?
One way I tried was using the DELETE * FROM sheet1 WHERE EXISTS (SELECT * FROM sheet1....) statement. However, I am getting errors - it deletes ALL records in sheet1 as opposed to only records returned by the SELECT* statement.
Help!!!
Anyone know what I did wrong, and how I can fix it?
Thanks!!!