>>>>The main thing here is to first get all possible combinations of yearmonths and models by cross joining yearmonths with Models and then use this result to LEFT JOIN with your actual table with data.
>>>
>>>Thanks Naomi
>>
>>You're welcome. Glad I sent it before the power went off for a few hours.
>
>Same weather system here, but no power loss (knock on wood). I just checked the forecast and it's supposed to change from snow to sleet and/or freezing rain in the next hour or two as the temperature warms up. I don't think I'll be doing any driving around this afternoon.

Snow huh?
I just realized I've been in the office all day without any heating (it's about 10C outside.)
After one of the coldest Decembers' on record we, so far, seem to be having the warmest Jan.
I have to smile when we get a cold snap and all the global-warming nay-sayers come out of the woodwork with the 'See - told you so, doesn't exist' argument but are V. quiet when the opposite happens. Of course the same could be said of some global-warming proponents but, regardless of which camp one is in, it's still pathetic to extrapolate for one short-lived, localized event......