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
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
Can you give a fuller explanation of what you are trying to do.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
This type of thing?
http://allenbrowne.com/func-09.html
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:
Meaning that Field1 should get the highest value from the list.Code:INSERT INTO MyTable Field1 Values(MaxList(Field1, Field2, Field3))
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
Did you see the link in post 3?
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 ?
Yes, if you put them in a standard module, not behind a form/report.