I need to maintain an in/out/balance table showing new cases, closed cases
and the running balance each day. I have pivot table queries showing a
running total of new, closed and live cases. Unfortunately not all dates
appear in all pivot tables so I can't just do GETPIVOTDATA becuase there may
not be a matching date. How can I select all dates up to the date in
question?

Example of what i have:

Date Open
02/03/08 1
17/03/08 4
07/04/08 6

I want to show:
Open Closed Bal
Opening 378
02/03/08 1 2 377
17/03/08 4 0 381