Returning inverse of a query

[caddcop]

I am working with an Access data base started by others that is actually part of a commercial product. The commercial product's license model is node locked. So I have been asked to develop some forms within the Access database which would allow minor updates and edits to the database, outside of the commercial program.
I can add tables, queries, forms, reports, etc. On a few tables, I am even allowed to add columns. However, as it is setup, there are certain tables that contain an ID field which is used as a join on queries.


As it turns out, unless a user enter certain data via the application, the second table does not get a matching record. Since one of my tasks it to develop a dialog box that can be used to add to these records, I need to query the database to return those records in Table One which do not have a corresponding record in Table Two.
Can someone suggest a method to accomplish this?

[pbaldy]

Have you tried the unmatched query wizard?

[caddcop]

I figured out that a left join would do some of what I wanted but I will looked at the unmatched query wizard. Thanx.

[pbaldy]

The wizard will create a query with a left join, so you're on the right track.

[caddcop]

I'm going to mark this solved, but my PC does not have all of the wizards installed, so I have to dust off my SQL hat to develop certain queries.
I found when I first started with Access, that certain results difficult to create in the design view but with the SQL mode I could adjust things pretty quickly. And if I wanted to, I could switch back to design mode to see how it could be done there.

[pbaldy]

Post back if you get stuck. Like I said, the wizard will create a left join, with a criteria of

Is Null

on the joined field from the "right" table (table 2 in your example). That will return those records in table 1 with no corresponding record in table 2.