November 19, 200619 yr Newbies If a field is a text type, and you are restricting it to a value list of "yes" and "no", is there a way of counting the number of records that have "yes" and also counting the number of records that have "no" ?
November 19, 200619 yr there are many ways of doing this best to post a file so we can understand what your trying to achive.
November 19, 200619 yr I would establish a relationship between a global field and the text field. Count(thisrelationship::thetextfield) will then give you the total of yes's if you set the global to "yes" and the total of no's if you set the global to "no". This simple formula can then be included in a calc field (unstored) or in a set field script step HTH Phil
Create an account or sign in to comment