Understood now - adding 100,000 days OK; adding 100,000 months overflow

Thank you for the education!

Thanks to all for the replies

kaj (11/5/2015)

---

The only thing I can think of that would cause this is if you have an unordered table, where n in one of the...

pietlinden (11/3/2015)

---

Why not just create a Calendar table with all the dates you want (no gaps!) and then just outer join the other tables to it? Then you can do...

Thanks Mike. That doesn't include the sums (to combine days that have values from more than one of the 3 tables), but I like the way the EntryDte field...

Thank you again for the assistance and for the information regarding the triangular join. Only took me a week to read Jeff's post, the re-post, and the discussions about...

Thank you both for your responses, and I apologize for the incomplete post (my first one). Reading the post from your signature I succeeded in violating just about everything.

As...