AnsweredAssumed Answered

Field Calculation

Question asked by datajim on Jan 18, 2018
Latest reply on Jan 22, 2018 by mikebeargie

iMac-High Sierra-FMA 16. I have a DB showing a local High School's football history going back 97 years. Year, game number, coach, opponent, scores, etc. fields. The games, wins, losses fields have summary fields that display the totals for each coach when I do a find for one of them and the historical totals when I show all. I want the total years field (which shows 97 years) to display the total years for each coach when I perform a find for a particular coach. It seems to me that it should be a simple calculation but I haven't found it. The year field has a value list of all years. Any suggestions? Thanks.