Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004

    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.;

  2. #2
    Join Date
    Jun 2004
    Florida, US
    you could group plant and supplier in a query and count the number of occurrences. then get the maximum numbers for each plant.

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    What context are you using this in? Do you only want the report to have information for the top supplier? What do the grouping levels look like?

    It may be as simple as a "SELECT TOP 1 " query... maybe not...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts