5 Replies Latest reply: Jul 26, 2011 11:58 AM by Debbie Pyykkonen RSS

    SHow Rows with Missing Data in reference table only

      I am trying to create a bookmark to pull only those records where the data is in one table but no match in the other table.




      Product ID is in Sales table but the Product ID is not yet added to the Product table.


      THus the Product Name is Null in the query

      I tried the below and no luck


      =IsNull([Product Name]) = 1