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 totals etc, and it's stupid easy.
Good point; the calendar table we use works fine. I was writing it for someone else & didn't want to assume they had such a table. Thanks for the answer!