AnsweredAssumed Answered

A COUNTIF TYPE OF FUNCTION

Question asked by khank on Oct 26, 2010
Latest reply on Oct 26, 2010 by philmodjunk

Title

A COUNTIF TYPE OF FUNCTION

Post

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.

TOTALING_INDIVIDUAL_NUMBERS.jpg

Outcomes