I have a working Crosstab query:
TRANSFORM Count(Items.ItemCategory) AS CountOfItemCategory
FROM Items INNER JOIN (CLIENTS3 LEFT JOIN [Item Transactions] ON CLIENTS3.ClientID = [Item Transactions].CustomerID) ON Items.ItemID = [Item Transactions].ItemID
GROUP BY CLIENTS3.ClientID
The output looks OK, but I want the query to also include records in CLIENTS3 for which there are no linked records in [Item Transactions].
How can I include these extra records?
Please let me know if you need extra information.