1. Link FROM the first table TO the second.
2. Right-click on the link and select "Link Options".
3. Make it a "Left Outer" join.
4. In the Select Expert, edit the formula manually and add something like this:

IsNull({Table2.LinkToField})

This will give you all of the records from Table1 that have no corresponding record in Table2.

-Dell

Did you select Default Values for Nulls in the Select Expert?

Edited by kevlray - 23 Jun 2015 at 10:26am

If you look at the top of the Formula Expert after clicking on the Formula button in the Select Expert, there's a drop-down that reads either "Exceptions For Nulls" or "Default Values for Nulls". You want it on "Exceptions for Nulls" for this to work.

-Dell

In what way is it not working?

-Dell