Show field name with count of zero

[ariel20029]

Hi,
Im trying to create a summary count of many queries. My issue is if there is a count of zero it appends no rows. Is there a way to show the Type (T4-Update Deal Number COM) with a 0 count?

INSERT INTO [Q13T- RECAP] ( TYPE, [CountOfDEAL NO_1], COMMENT )
SELECT "T4-Update Deal Number COM" AS [T4-Update Deal Number COM], Count([T4- Update Deal Number- COM].[DEAL NO_1]) AS [CountOfDEAL NO_1], "" AS COMMENT
FROM [T4- Update Deal Number- COM]
GROUP BY "T4-Update Deal Number COM", ""
HAVING ((("T4-Update Deal Number COM")=Nz(Count([T4- Update Deal Number- COM].[DEAL NO_1]))+0));


Thanks for all of your help.
Sharon

 

[Joe4]

One way is to have a tables that list each possible Type.
Then do a Left join from this table to the Table/Query which includes all your record counts.

 

[ariel20029]

Thank you , I will give that a shot.
Sharon