Hi Listers, I've build an outer join with the qualification:
'Company-ID' LIKE ("%" + $Company-ID$) Since it's an outer join I'd expect it to show the entries that match and those that don't match. Why is it only showing entries that match? I'm only interested in items from Form 1 that do not have corresponding items in Form 2. What qualification would do that? Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"