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.

       

      Example:

       

      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