Query for data that is in one table but not another

[plannerg]

Hi, Im a bit of a hack when it comes to queries but I have two tables, one with a heap of data in it and another table with some of the data from the first table in it. Can I create a query that will tell me the data that is in the first table but not the second table? Both tables have a common ID field. A big thanks to anyone who can help!!

Greg.

 

[jdraw]

Look up the Access Unmatched query in the query wizard.