0

Jet Result - filtre result < filtre result

Nutzer

February 07, 2018 10:06

Answered

Follow

Hi Guys,

 

anyone here help me to get a result for following:

 

 

Thanks!

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Harry Lewis February 07, 2018 16:18

  Hello David -

  I'm not sure what you are trying to do with the NL("Rows") function as a filter (which is not possible).

  Is your goal to retrieve all Nr. values where the value in field #68 is less than the value in field #99000778 ?

• 0
  
  Nutzer February 08, 2018 06:16

  Dear Harry,

  yes, i want alle articlenumbers, where 68 < 99000778; whats the solution & why i dont can use the rowfunction?

   

  Thanks for your help

• 0
  
  Harry Lewis February 08, 2018 15:15

  Hello David -

  The NL("Rows") function returns all field values from the database that match the filter criteria and then makes as many copies of the entire row in which that function resides as necessary to list all those field values.

  You simply want to compare one field in a record to another field in the same record.  What you would want is something like this:

  =NL("Zeilen";"27 Artikel";"1 Nr.";"68 Lagerbestand";"=""<""&NF(;""99000778"")")

• 0
  
  Nutzer February 09, 2018 09:25

  Harry, thats fantastic, its works for me; thanks!!!!