Discussions

Expand all | Collapse all

Need help creating a Frequency report that will count from 2 different fields

  • 1.  Need help creating a Frequency report that will count from 2 different fields

    Posted 11-21-2017 18:21
    In a table,  Field X and Field Y  are both multiple choice with identical choices.    I need to create a Frequency report that will count the choices selected in both of these, as if they were only one field.     Is this a possibility?         For instance:    On one record,   Field X  shows "cat",  and on a different record  Field Y  shows "cat".    I need to run a frequency report that will show that "cat" was selected twice.   


  • 2.  RE: Need help creating a Frequency report that will count from 2 different fields

    Silver
    Contributor
    Posted 11-21-2017 19:02

    If you have your selection lists in related parent tables, you can create summary fields in the parent tables that would allow you to see how many times the 'cat' record was selected in a child record.

    Summary fields essentially count the number of child records that meet a condition you specify.

    In this case, when you go to create the summary field, you can just click through without specifying conditions.

    You'd then consult the parent selection lists' summary fields to see how many child records chose the 'cat' record, or the 'canary' record, or the 'canine' record, etc.

    Hope this helps.