I have a query in Access that lists all my SubCategories and also counts the products within each SubCat.

When I run the query, SubCategories without any products in them will not appear
...because they dont have anything to be counted I assume...

Is there a way to list all subcategories and have the product count appear as a 0 if it doesnt find any products within the subcat?

Is there an easier way within the actual page to make this query work??