Newbies fmsimon Posted November 19, 2006 Newbies Share Posted November 19, 2006 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" ? Link to comment Share on other sites More sharing options...
Stuart Taylor Posted November 19, 2006 Share Posted November 19, 2006 there are many ways of doing this best to post a file so we can understand what your trying to achive. Link to comment Share on other sites More sharing options...
Inky Phil Posted November 19, 2006 Share Posted November 19, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6368 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now