Recent content by tushar05

Thanks Mr. B. I would want to keep B, I dont want to delete all records. If table 1 has 3 Bs and table 2 has 1, I want to delete only one and keep one. Regards, Tushar

Hi, I am new to Access. Can someone please me with following query. It compares data from two tables and deletes entry from table 1 for entries in table 2. I have two tables with one field each. Sample data- Table 1:Field1- A B C B Table 2:Field1- B Expected Query Result A C B Thanks...