total query returning values 0 too

[diegomarino]

hi, i have this query

SELECT IscrittiOCF.REGIONE, Count(IscrittiOCF.DENOMINAZIONE_SOGGETTO_ABILITATO) AS ConteggioDiDENOMINAZIONE_SOGGETTO_ABILITATOFROM IscrittiOCF
WHERE (((IscrittiOCF.DENOMINAZIONE_SOGGETTO_ABILITATO)=[Maschere]![OcfAnalisi].[form].[BancaAttualeCB])) OR ((([Maschere]![OcfAnalisi].[form].[BancaAttualeCB]) Is Null))
GROUP BY IscrittiOCF.REGIONE;

as you can see, it counts the guys that works in a specific bank ( IscrittiOCF.DENOMINAZIONE_SOGGETTO_ABILITATO) grouping by regions (IscrittiOCF.REGIONE).

since very often there are region with no people, i get only the regions with people in it; is there any way to show the regions too withouth guys showing "0" as result?

[ranman256]

You want an OUTER join. Dbl-click the join line in your query,
Pick SHOW ALL Regions ,and some from the other table.
Bring down the tRegions.name field,and the tClient.name

You will see null for the missing clients not in region.
Convert null to zero with NZ function.

[diegomarino]

i have no join line, my query is based on 1 table