AnsweredAssumed Answered

Count based on Multiple Fields

Question asked by SchoolData on Jul 3, 2013
Latest reply on Jul 5, 2013 by schamblee

Title

Count based on Multiple Fields

Post

     I have a need to count the number of records that have certain vaules in particular fields.

     I need to know the number of records that have:

     Value X in Field1, Value Y in Field 2, Value Z in Field3, and "" in Field 4.

     For other purposes, I need to populate a field with "1" for the records that have:

     Value X in Field1, Value Y in Field 2, Value Z in Field3, and "" in Field 4.

Outcomes