>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?
If you want
records in table A that don't have a match in table B, a subquery will do:
select * from TableA where KeyField not in;
(select KeyField from TableB)
>And Is there any good websites on intro VBA and access programming?
This seems to me like a separate question; in this case, you should start a separate thread to avoid confusion.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
