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

Question

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

QuickBaseCoachD · Answer

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.

Sign up

Login to the community