Thank you Michel,

That worked! But I had to make the joins to the crosstab query left joins,
because some diagnoses and some categories are not returned by that query.

I did not think of creating all combinations of Diagnosis and Category
first, then doing the join. Now that seems the obvious solution.

Made my day!

Ragnar