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

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
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.   
Photo of Daniel Oates

Daniel Oates

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of Chris


  • 4,430 Points 4k badge 2x thumb

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.