3 Replies Latest reply on Jul 5, 2013 8:32 PM by schamblee

    Count based on Multiple Fields

    SchoolData

      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.