Count

[Mike Hughes]

I'm trying to count the number of cases where the license was suspended between two dates. I just want one number returned but I keep getting a list of numbers (i'm guessing they correspond to the dates)
Is there a way to do this?

SELECT
Count(LICSUSP.CASEID) AS CountOfCASEID

FROM LICSUSP

WHERE

LICSUSP.CERTIFIEDDATE>=[START DATE] And LICSUSP.CERTIFIEDDATE<=[END DATE]

GROUP BY LICSUSP.CERTIFIEDDATE

 

[boblarson]

Get rid of the Group By LICSUSP.CERTITIEDDATE part.

 

[Mike Hughes]

Thanks that should do the trick