[AccessD] Counting a text field

Stuart McLachlan stuart at lexacorp.com.pg
Sat Dec 2 05:05:47 CST 2006


On 2 Dec 2006 at 3:17, John Eget wrote:

> 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?

=Sum(IIf(myField = "Y",1,0))


-- 
Stuart





More information about the AccessD mailing list