In Reports,I am trying to exclude status DENY and CANC files from my report.  If I build a report condition that says "equal to" DENY or CANC, I get only those files with status equal to DENY or CANC, BUT if I change the condition to "NOT equal to", I still get DENY or CANC files (along with all other status,too).

Detailing the bigger picture, I am using Estimated closing dates on all files for a date range of roughly a month.

I am looking for a way to exclude ony DENY and CANC status only in this report.

Any Ideas?

Thanks for your help,

John Hoopes

set the second condition to not equal CANC (make sure you selected "and")

This should work fine you should see the following in the grid after you have closed the condition dialog box

cn: NOT = 'CANC'cd:AND cn: NOT = 'DENY'

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.