Another aggregate question

I want to use something of this psuedo code:



select count (feildMgr) from tblM where [tblM.feildMgr] = (Matt)



but when i actually script a query like this out, it doesn't parse the Managers names, it just shows a count of all the managers, regardless of names.



Should there be a nested query? Please help!!

This should do it:



select count (feildMgr) from tblM where feildMgr = 'Matt'