Skip to main content
Question

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

  • November 21, 2017
  • 0 replies
  • 21 views
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.   
    This topic has been closed for replies.

    • ChrisChris
    • Registered
    • November 22, 2017

    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.

    Terms & ConditionsAccessibility statement