Maybe asking in an Access newsgroup would help more.

Mir Khan wrote:

there are 2 tables table A with 50 records and Table B with 5 records...what
shall i do so that the 5 records from table B should get deleted from Table A
(assuming all 5 records in Table B are in Table A). and finally Table A
should have 45 records.

--

Dave Peterson