[AccessD] Counting a text field

...filtering your query for Y and using the Totals: Count on the pk field 
should work.

William Hindman
----- Original Message ----- 
From: "John Eget" <joeget at vgernet.net>
To: <AccessD at databaseadvisors.com>
Sent: Saturday, December 02, 2006 3:17 AM
Subject: [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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>