Hi
I am trying to Delete from one table depending where records match between to tables. I’m using Access 97 due to the type of database
So i have a table with a list of codes and a second table with the list of codes which i want to delete, this is my statement:
DELETE tblProduct.*
FROM tblProduct
WHERE tblProduct.ProductBarcode = tblProduct_SU.ProductBarcode;
From this i get a Parameters box asking my to enter something.
Any help would be very grateful
Thanks in advance
Martin