Do not display 0 if there is no count

[Tcurtis]

I am using a query to count how many Departments there are according to a set of criteria. The count always shows a blank field if the field has nothing in it, How do I make this not show a blank field. I am including my sql below.

SELECT TOP 10 tbl_Cause_Code_Dashboard.Description, Count(tbl_Cause_Code_Dashboard.Description) AS CountOfDescription
FROM tbl_Cause_Code_Dashboard
WHERE (((tbl_Cause_Code_Dashboard.Plant)=[Forms]![frm_Cause_Code_Dashboard]![Plants]) AND ((tbl_Cause_Code_Dashboard.OEM_Model)=[Forms]![frm_Cause_Code_Dashboard]![Model]) AND ((tbl_Cause_Code_Dashboard.Cause_Code_Long)=[Forms]![frm_Cause_Code_Dashboard]![Cause_Code]))
GROUP BY tbl_Cause_Code_Dashboard.Description
ORDER BY Count(tbl_Cause_Code_Dashboard.Description) DESC;

 

[Joe4]

Not quite sure I follow.

Can you post a small sample of your data, what result you are seeing, and what your expected result should look like?

 

[Tcurtis]

The highlighted cells are what I am wondering about. The department is blank with no counts but it keeps showing up in my query output.
[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Dept[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Count[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Dept 1[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]45[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Dept 2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]25[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Dept 3[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]36[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"] [/TD]
[TD="class: xl66, bgcolor: yellow"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Try adding the DEPT field to your criteria (WHERE) section, excluding records where that field is blank.

 

[Tcurtis]

Works Great!! thanks

 

[Joe4]

You are welcome!