0

Filter if field not equal to a field in a different table

Jet Reports Historic Posts

November 18, 2013 05:01

None

Follow

Hi,

Is there any way to filter on records if a field in one table does not equal a field in another table.

I want to look at all records in the Bin Content Table and identify those where the Unit of Measure Code on the Bin Content is different to the Base Unit of Measure for that item no. on the Item Card.

At the moment I am returning all Bin Content Records and the hiding those that agree.

Regards

Phil

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts November 18, 2013 16:27 Official comment

  Hi Phil,
  
  Something like this might work:
  
  =NL("Rows","Bin Content",,"Unit of Measure Code","=""<>""&NL(,""Item"",""Base Unit of Measure"",""No."",NF(,""Item No.""))")
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 19, 2013 00:57

  Hi Hughes,
  
  Perfect.
  
  Thanks for the prompt reply.
  
  
  Regards
  
  Phil