>>>>>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.
>
>Thanks. This reminded me I have to shovel my driveway. Will do it right away.

Has it stopped snowing there already? Or maybe not. I always wait until it stops snowing, unless it's a real whopper and I don't want to shovel a foot or more all at once. One of my neighbors is a zealot. He's out there every hour or two, keeping his driveway black from edge to edge. In the summer he mows his lawn twice a week. Lyle likes things tidy ;-)