eliminating records

W

wmorgan

I have two tables and would like to cross reference the two tables and
eliminate those records which do not have a match from Table A in Table B
based on one key field. Any help would be greatly appreciated as I am fairly
new to Access.
 
N

Nikos Yannacopoulos

You need a query like:

DELETE * FROM [Table B]
WHERE [Table B].[IDfield] Not In
(SELECT [Table A].]IDField] FROM [Table A])

HTH,
Nikos
 
Top