Deleting an entire row in an access table

[mms180]

hello everyone, i'm a beginning programmer and i need help writing code to delete a row at a time...
i have two tables and where there is a match in one of the columns, i want the row deleted in one of the tables.

I use a "DELETE FROM [] WHERE Value1 = Value2" statement but it deletes all of the records in the table
please help me

 

[mwolf00]

Is this what you need?

DELETE FROM table1 WHERE field1 IN (SELECT field2 FROM table2) Get the Best Answers! faq333-2924
"A witty saying proves nothing." - Voltaire
mikewolf@tst-us.com

 

[mms180]

thank you very much mwolf00 i appreciate it greatly