Discussions

Expand all | Collapse all

A report to show the count of times that a resource in a related table was used in another table's records

  • 1.  A report to show the count of times that a resource in a related table was used in another table's records

    Posted 10-19-2018 16:06

    Looking for some guidance

    I have three tables, table A contains daily records of delivery routes, table B contains the vans used, table C contains the names of the drivers

    I want a report from table A, grouped by name of the driver, to show me the count of the van that they use the most (aka the most frequent pairing of name X and van Y, and the # of times). The final desired result would look like:

    Dave     Van 1     107
    Eric       Van 8     88
    Tim        Van 4     45
    Roger    Van 5     134

    Thanks to anyone taking a look at this


  • 2.  RE: A report to show the count of times that a resource in a related table was used in another table's records

    Posted 10-19-2018 16:08
    np,
    Make a summary report type by driver by van.
    It will initially sort alpha.  But then click twice on the column for the counts and it will sort high to low, then SAVE.


  • 3.  RE: A report to show the count of times that a resource in a related table was used in another table's records

    Posted 10-19-2018 16:15
    Thanks for the quick idea! That'll do the trick