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
