0

Filter by Two Not Equal Statements

Jet Reports Historic Posts

April 29, 2010 23:13

None

Follow

That's the information I was missing. Thanks for the solution, RMW.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts April 30, 2010 22:11 Official comment

  When using unequal as a filter you also have to invert the OR function.
  
  Try '<>REC*&<>NEW*'
  
  When you use '<>REC*|<>NEW*' you are asking for all that
  isn't starting with REC
  OR
  isn't starting with NEW
  and that is about everything.
  Because what starts with REC matches the 'isn't starting with NEW'
  
  HTH
  
  rmw

• 0
  
  Jet Reports Historic Posts April 29, 2010 23:13

  Hi All,
  
  I'm trying to figure our a filter which removes two different values. The filter works for one (Ex: <>REC*) but it will not work with I list two (Ex: <>REC*|<>NEW*) I've checked the Jet Help documentation and there is nothing that says you can't use two not functions. Can anyone make any suggestions?
  
  Thanks for the help!