2 Replies Latest reply: May 3, 2012 7:10 AM by Anne Duffy RSS

    Comparing 2 tables - not working --

      Hi Experts

       

      Please help --

       

      I have 2 tables which I wish to compare for matches. I have created Unique Identifiers [SearchNos] on each and now wish to create charts when the unique identifier is common for both tables.

       

      Can you please have a look at screen shot and explain why its not working how Id like.

       

      I wish for it to only count the first row where SearchNo = SearchNo1, yet it is counting both !


      Can anyone please advise ?

       

      Thanks


      A

       

      Error 1.bmp