Only want to show records that DON'T have a match

[mollie]

Hi,

I'm linking to tables

Table 1 Table 2
OrderID OrderID
Name UPS Tracking number


I only want to show the records from table one that DON'T have a record in table 2. (Meaning, not all of the orders were shipped via ups). This should be easy, but I just can't get it.

Thanks much,

 

[rhinok]

Don't worry, this is pretty simple:
[ol][li]Create a left outer join from table1.order_id to table2.order_id[/li][li]Add the following statement to your record selection criteria: IsNull({table2.order_id})[/li][/ol]This will show you all orders in table1 where there are no corresponding orders in table2.

Hope this helps!