0

Return value from one table based on a range from diff table

Jet Reports Historic Posts

April 17, 2013 04:37

None

Follow

Hi everyone,

I am new to jet reports and have been leaning to do certain things.

I am trying to get a report to pull data from another table based on a range in the second table. The data to be returned is also located on the second table.

See the attached spreadsheet.

Thank you all.

• Journal Register-v3.xlsx

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts April 24, 2013 07:29 Official comment

  Hi Okumud,
  
  You can use a row in your maintable to show all Entry No's
  (cell C6) =NL("Rows","Table 1","Entry No")
  
  Then you can use a filter for the second table, so this one you use next to the entry no
  (cell D6) =NL(,"Table 2","No","From Entry No",">= C6","To Entry No.","<=C6")
  
  Table 1 = the main database
  Table 2 = table to find the no.
  
  This should work

• 0
  
  Jet Reports Historic Posts April 17, 2013 14:56

  Hi,
  
  I assume you can just create a range filter by concatenating the values together with a .. in between like this:
  
  =C10&".."&I10
  
  Then you can use that as a filter for the No. field in your second table. Does this help?
  
  Regards,
  Hughes