Function to return the highest value

[harryklein]

Hi,



I would like to ask, if you are aware of a function that returns the max-value of a given number-range.
Like the MAX in excel, not the one can be used in sql-query.
Like this:

Max(1,2,3) returns 3.

Thank you

[Bob Fitz]

Can you give a fuller explanation of what you are trying to do.

[pbaldy]

This type of thing?

http://allenbrowne.com/func-09.html

[harryklein]

I need to insert records into a table, and there is a field where I need to put the highest value out of four other fields.
If there would be a function like MaxList, then I would do something like this:

 
INSERT INTO MyTable Field1 Values(MaxList(Field1, Field2, Field3))

Meaning that Field1 should get the highest value from the list.
I know, nested IIF-s could be also used, but in case there are more fields in the query, it is a bit confusing to build the expression.

Thank you

[pbaldy]

Did you see the link in post 3?

[harryklein]

I have just red it, yes, this is exactly what I need.
Thank you.
I am not sure (of course can try easily):
if I put these functions into a module, then I can use them in a query ?

[pbaldy]

Yes, if you put them in a standard module, not behind a form/report.