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 ?





      Error 1.bmp