12 Replies Latest reply: Feb 3, 2016 11:01 PM by Kar Kit Chong RSS

    Selecting Records that does not exists

      Hi All,

       

      As I am in the midst of developing a new sheet of data analysis for my work.

       

      Background
      2 tables are joined (default: inner join via PID)

      1. tblProduct
      2. tblTransactions

       

      Current

      I am now able to select which Product and which Year is it that I would like to see transactions that have occurred.

       

      New Development

      But for this new page, I would still be selecting the Year as a selection criteria, but I would like to see which are the products that has no transaction for the year, which means there would not be any records inside tblTransactions