Fun with Max

[Hurican]

Here's a challenge.

Say you have a fields and any number of records.

This is a number.

These numbers are not unique.

The same number can come up many times throughout the records.

Within a found set based on a date range, how would you script (or calculate) the Count of the number that comes up the most (Max), and then display the actual number in a Results field?

[-Queue-]

Do a search for +mode +median. I think you'll find a Custom Function that works nicely for this.

[Hurican]

Thanks Queue!

That link has given me a structure to work with. Even though I have alot to work out, and most likely re-modify some of my relationships (to get better performance), I should be able to make this work.

This database is regarding statistics, so there will be alot of numbers flying around. :-)