Count 2 possibilities in same query/form

[cbrou]

I am trying to make a query or form that will display a count for the total number of tickets "open" and at the same time display the number of tickets "closed". I can do each seperately in queries using the following SQL:

SELECT Sheet1.[Client ID] AS School, Count(Sheet1.[Assigned To]) AS [Open Tickets]
FROM Sheet1
WHERE (((Sheet1.Status)="Open"))
GROUP BY Sheet1.[Client ID]
HAVING (((Count(Sheet1.[Assigned To]))>0))
ORDER BY Sheet1.[Client ID], Count(Sheet1.[Assigned To]);

Is there a way to display the results of "open" count and "closed" count in the same result?

 

[cbrou]

Pat, you are the man. I have been looking all over the net for weeks and could not put my finger on it.

Thank You!

 

[David R]

Errr...actually Pat's NOT the man...but she is a great help.