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.

Dept	Count
Dept 1	45
Dept 2	25
Dept 3	36
	4

<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

 

[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!