Create a Summary Report from a Multi-select Dropdown Field

Suppose I have a Multi-select field with options (A, B, C) and 100 records where the field is used. Is it possible to create a report that counts each time an option is selected in each record? ...

reports and charts

Tables and fields

Tips and tricks

_anomDiebolt_

Qrew Elite

7 years ago

If you suffix and prefix the multi-select text field and the option string with the three characters " ; " (ie space, semicolon and space) you can absorb the oddball case where one option is a sub-string of another:

ToNumber(Contains(" ; " & [field] & " ; ", " ; dog ; "))
ToNumber(Contains(" ; " & [field] & " ; ", " ; cat ; "))
ToNumber(Contains(" ; " & [field] & " ; ", " ; fox ; "))
ToNumber(Contains(" ; " & [field] & " ; ", " ; ox ; "))

In the above I used ToNumber() instead of Mark's If() to convert from text to number.

AdamKeever1
Qrew Commander
7 years ago
That is very useful. How did you learn about this?

Forum Discussion

Create a Summary Report from a Multi-select Dropdown Field