THanks Jack,

It now runs, but does not pull the zero values i was hoping for. Do i need to join a calendar table on to it?