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.


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

      1. tblProduct
      2. tblTransactions



      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