Yes, I've already made my declarations.

The only issue with doing it this way is that I need to be able to input different dates from a gui as oppose to hard coding a Start Date...

I need to explicitly say which column to get information from to pass through to a new report or query level. Since the temporary table columns are not stored...

That works great, Lenny. But one issue...how do I account for Null values. I don't want them to be included in the average. I'm not sure how...