08-17-2008 04:27 PM
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?
08-17-2008 04:32 PM - edited 08-17-2008 04:33 PM
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.