11 Replies Latest reply: Sep 10, 2013 1:40 PM by Phil Speight RSS

    Joining Tables & Linking Tables = Headache

    Phil Speight

      I have posted this query before, but I didn't explain myself very well last time.

       

      I have a problem with duplications in a report I am producing. After a bit of investigative work I now know my issue is to do with linking / joining tables, but I just can't quite get what I need.

       

      All I need to do is link the tables in such a way that will associate a billing cycle correctly to the person & date without getting the duplications.  Joining tables is blowing my mind, no matter how many times I try to get it.

       

      I have attached a file to demonstrate what I need.  Please note there are more than 2 fields in each of my real tables, the attached is for demo.

       

      Any help appreciated.

       

       

      Thanks

       

       

       

      Phil