2 Replies Latest reply: Nov 2, 2010 10:49 AM by Marcel Olmo RSS

    Range Question

      I have the following Bank Schedule in a table:

       

      ID From To

      1 1/1/2010 1/8/2010

      2 1/9/2010 1/20/2010

      3 1/21/2010 1/25/2010

      .

      .

      n 12/25/2010 12/31/2010

       

      The above schedule does not follow any specific patterns & depends on bank holidays etc. I have a different transaction table, which is below:

       

      Date Amount

      2/2/2010 10

      2/22/2010 20

      .

      .

      .

       

      How do I filter transaction table depending on which ID is selected?

       

      Thanks,

      Dinesh.