>>>>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.
>
>Must have been a local thing. Didn't happen here :-}
:)
If it's not broken, fix it until it is.
My Blog