AnsweredAssumed Answered

max value from summaries for given field

Question asked by philkhor on Mar 2, 2017
Latest reply on Mar 2, 2017 by philmodjunk

I have two related tables, honeybee colonies and colony inspections. I have (with much help from philmodjunk) managed to display previous records when I'm entering new data, and I have created summary fields so that I can display each colony with the average/total or whatever for given fields. What I now want to do is show at the bottom of the page the colony with the best score for a given field, e.g.:

colonyave temperamenttotal honey yield
Ave sizetotal amount fed
C15342
C241037
C32254
C43257
Overall summary
best temperament (max)highest yield (max)best size (max)most thrifty (min)
C15
C210
C35
C45
C27
C47

 

Any chance?

Outcomes