0

Does not equal NL "First" Lookup in Jet Function Wizard

Jet Report Rookie

January 15, 2020 13:37

None

Follow

Hi,

I cannot get my NL first lookup to filter based on a does not contain filter. Please See the "Source ID" filter in the image below.

 

 

Any Suggestions?

 

Thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 2
  
  Eric Kornmeyer January 15, 2020 16:46

  You need to wrap it in double quotes. "<>SOC-*"

• 0
  
  Jet Report Rookie January 15, 2020 16:54

  Thanks Eric that worked. That makes me feel pretty dumb because I tried the same thing yesterday but was getting an error regarding @@. All I had to do was put it quotes and use an If Statement to tell it what to do when there are blanks.