Jim_Shelton Posted February 19, 2008 Share Posted February 19, 2008 In 8.5, I have closed my mind on a search. I have 862 records where quote is quote, and 469 records where quote is active. Each record has a company name and the company name can be in both sets. I need a final list of companies where quote is quote and the company is not in the active list. Any help will be appreciated. Jim Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 19, 2008 Share Posted February 19, 2008 If I followed that correctly, you want a found set of records where quote is "quote" and where the company name is not ALSO in a different record where quote is "active"? Define calc field, ActiveOne, = Case (quote = "active", 1) result type number Define relationship, selfjoin of table to itself based on Company = Company (call it "Selfjoin") Define calc field ActiveCount, = Sum (SelfJoin::ActiveOne), result type number, evaluate even if all field values are empty. Now do a search for quote = "quote" and Activecount=0 Quote Link to comment Share on other sites More sharing options...
Jim_Shelton Posted February 20, 2008 Author Share Posted February 20, 2008 Thanks, Worked Great. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.