Merging Two Completely Different Tables
Greetings, I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two...
Forum Discussion
Thanks for responding.
The 1st table shows a total amount accumulated over the start and finish date for that record. The 2nd table shows periods of time that the accumulated amounts may or may not correspond to. I want to show that Name1 has amounts accumulated before period1 started as well as some accumulated during period1, etc. I realized after I made this post that my current idea doesn't account for overlaps before the first period begins or after the last period ends. My example output is what I am going for as a result of putting the data together.