Hi visbek !
It took me some time to get the picture 🙂 but after that it was obvious. I think the problem is in the way the type info view is JOINDed to other two views. The right approach would be to make separate summaries from qryPublicate and qryInfoAanVraag and JOIN them to qryInfoType to get the description. I will only scratch the SQL:
SELECT TOP 100 PERCENT
<columns from qryTypeInfo>, <columns from Tmp_Publicate>, <columns from Tmp_InfoAanVraag>
FROM qryTypeInfo
LEFT OUTER JOIN (SELECT type_info_id, SUM(aantal) AS Publicate_aantal, SUM(kostprijs) AS Publicate_kostprijs
FROM qryPublicate GROUP BY type_info_id) AS Tmp_Publicate
ON (Tmp_Publicate.type_info_id = qryTypeInfo.id)
LEFT OUTER JOIN (SELECT type_info_id, SUM(aantal) AS InfoAanVraag_aantal
FROM qryInfoAanVraag GROUP BY type_info_id) AS Tmp_InfoAanVraag
ON (Tmp_InfoAanVraag.type_info_id = qryTypeInfo.id)
Additional columns for COUNT and the difference should be added, too.
I hope this will help,
Regards,
Goce Smilevski.