You want to create a table or query that lists out all of your regions individually.
Then, create a Left Join query from this first table/query to your Inventory table, joining on the Reg field.
Then, when returning the Inventory, use a calculated field using the NZ function to return 0 where they are not found.
So let's say that we have a table named Regions with all the different regions in it.
And the count query you show above has been named "qryInventory". Then we just join those two objects and add a calculated field like this (SQL View):
Code:
SELECT Regions.Reg, Nz([CountOfStatus],0)+0 AS TotalCount
FROM Regions LEFT JOIN qryInventory ON Regions.Reg = qryInventory.Reg;
Which will return a result that looks something like this:
Code:
Reg TotalCount
1 3
2 0
3 1
4 0
5 1
6 0
7 1
MC 0