Showing results for 
Search instead for 
Do you mean 

Advanced Query 'Does Not Contain' Logic Needed

New Member
Posts: 3
Country: USA

Advanced Query 'Does Not Contain' Logic Needed

Am I the only one who feels that the Advanced Query in ACT! 2007 is missing a 'Does Not Contain' operator to go with the 'Contains' operator?  We want to lookup ID/Status field containing a certain value, then narrow by records that do NOT contain certain values.

So far I have had to export to Excel and apply advanced formulas to accomplish this.  Is there another way I am missing or is there a developer add-on solution for this?



Silver Contributor
Posts: 1,813
Country: USA

Re: Advanced Query 'Does Not Contain' Logic Needed

[ Edited ]

They have greatly improved the options here for 2009. With the new platinum care promotion, it's almost a no brainer.  One thing still on the wish list though is a "NOT" criteria in addition to "AND" or "OR". With that we could do just about anything.


Message Edited by jonmklub on 08-17-2008 04:33 PM
Test Drive Act! and Quickbooks over Citrix

Jon Klubnik|
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider