I would like to pull records that meet multiple criterion. For example, I would like records to be called when a specific field associated with the record is not equal to "NEW" "ABDN" or "DISC"

My record filter looks like this after:

Date filter AND
{mfp_list.last_result_code}<>"NEW" OR
{mfp_list.last_result_code}<>"ABDN" OR
{mfp_list.last_result_code}<>"DISC

Am I doing something wrong or did I omit something vital. Thanks in advance.

-Neal

Edited by npatel - 10 Jan 2011 at 6:24am

I would alter it a bit differently as you want all of your ORs parenthed to act as one part of the statment Date filter AND ({mfp_list.last_result_code}<>"NEW" OR {mfp_list.last_result_code}<>"ABDN" OR {mfp_list.last_result_code}<>"DISC )