Unanswered: Most Frequently occuring text in A field
I'm working on a report and I have a question regarding text fields.
I've got a one field ([Plant]), which simply has a list of plants.
For each plant, I have several suppliers (in a field [supplier]).
Is there a way to put in a report the supplier that occurs most frequently for each plant.
For example, If SupplierA has 6 entries and SupplierB has 4, it lists supplier A.;