September 12, 200421 yr Newbies how do i go about creating a new field (FieldB) to count the number of times FieldA contains the number 5 over a sorted set of 20 of 60 records. basically i am not sure of the field type and the formula/funtions to use. i am sure this can be done, it seems so simple to do in theory but who knows. thanks.
September 13, 200421 yr Hi, g4, and welcome to FM Forums! Unless the number 5 has a special significance, you're best off using subsummaries. That is, if you'll also want to know the number of occurrences of the number 6, and 7, and 8... use subsummaries. If 5 is not just an exemplar, but is really significant, create a calc number field called Always5 that is always equal to 5. Make a relationship from Always5 to FieldA and call it FindTheFives. Now the calc you want for FieldB is Count ( FindTheFives::FieldA ) This will display the number you are looking for, irregardless of the current found set or any sorting. HTH. Jerry
Create an account or sign in to comment