Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sorry, was a bit confused...
that should help
Finally managed to apply this to my data model.
It worked perfectly!! Thankyou.
If you get chance please could you explain your methods so I can learn from it and apply it to other reports in the future.
Thanks again
Phil