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

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered

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
Photo of Tyler Parker

Tyler Parker

  • 860 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
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.
(Edited)
Photo of Tyler Parker

Tyler Parker

  • 860 Points 500 badge 2x thumb
Thanks for the quick idea! That'll do the trick