[AccessD] Counting a text field

Thank you Stuart, it worked perfectly

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, December 02, 2006 6:05 AM
Subject: Re: [AccessD] Counting a text field


> 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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>