AnsweredAssumed Answered

PatternCount... won't

Question asked by AnitaWoods on Jun 13, 2012
Latest reply on Jun 13, 2012 by AnitaWoods

Title

PatternCount... won't

Post

I am an novice user with a Contacts table listing mother's name, and a Birth table listing one record for each of her children.  Contacts is related Contacts::ContactID = Birth::ContactID to a second occurrence of the Birth table. I have the following calculated field in the Contacts table, counting how many cesareans she's had from the Birth::BirthOutcome field:

PatternCount (Birth 2::Birth outcome ; "CS") + PatternCount (Birth 2::Birth outcome ; "ERCS") + PatternCount (Birth 2::Birth outcome ; "RCS")

It seems to only be counting one, no matter how many births she has in the Birth table with more than one.  What am I doing wrong?

Outcomes