A COUNTIF TYPE OF FUNCTION
I believe this only can be handled through a "count" function.
The first Layout is named "SeasonNums", it has 3 fields (ID, Name and MeetNums).
There are 10 records with a column of daily updated numbers named "MeetNums" (3-12's, 2-10's, 2-9's, 2-8's and 1-11).
I am looking to have a total for each individual number to appear on the second layout named "NumsList", this is where I want those totals to appear. Numbers will range from 0 to a max of 23.
This is where I'm getting hung up. Wouldn't I need some sort of list of the 23 numbers to relate the incoming number totals to from "SeasonNums"?
I do have both layouts linked via relationship.
What is the easiest way to do that?
I don't want a summary because I want to use those numbers later on.
See attached file for reference.