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