>Hi All,
>I would need some help on using standard code to do this.
>I have table A and table B, table A contains all informations in table B plus more. Now, I need to extract table A contents that are not in table B, how can I do that? Can someone give me some simple codes?
>And Is there any good websites on intro VBA and access programming?
>Thanx
>Tom
Assuming you have a key field identifiying a record as unique :
select * from tableA where IdentifierField ;
not in (select IdentifierField from tableB)
Cetin