I need your help in MS Access…

There are 2 tables Table A with 50 records and Table B with 5 records
(similar records), I want to delete the 5 records of table B from Table A so
that in the end Table A should have 45 records (assuming all 5 records of
Table B are in Table A)…

Please help me…

Mir Khan wrote:
.... but this is a SQL Server group!

In SQL Server:

DELETE FROM A
WHERE EXISTS
  (SELECT *
   FROM B
   WHERE B.col1 = A.col
    AND B.col2 = A.col2
    AND ... etc ) ;

Aggregate Function Error
unique variable per connection
RFC: EXISTS (SELECT ... FROM) optional?
use subquery result in Selet statement
add working days to a date