>>>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.