[AccessD] Counting a text field

I am trying to use one query to count within a series of records how many total items of a field are a Y.   So If I have lets say ten records and 4 of a specific field are a Y then one of the outputs of a calculated field would be a numerical 4.  Does anyone have an idea how to do this?

Thanks
John