Calculated Fields in QBE "...wrong number of arguments" Message

[Guest]

This should be easy.... but now, it is just getting frustrating
In a calculated field I want to use the expression "Max" to find largest
number of a series of numbers. In QBE, on the FIELD row I've written:

MaxOfMax: Max(85;45;26;95;35;15;75)

as soon as I try to leave the FIELD line of the query or execute the query,
I get the error "The expression you entered has a function containing the
wrong number of arguments"

Normally, I want to use result from a number of different querys, and
evaluate them to find the MAX, but until I can get the above expresion
working, there nopoint.

If I use commas(,) instead of semicolans( i get sytax errors, and I'm
pointed to the commas.
The same, or more or less the same expression (=Max(85;45;26;95;35;1;75), in
a cell of Excel returns the correct answer: 95

what is wrong with me or access - can you just not use this function this
way??
If I use:

MaxOfMax: Max(45)

then the query runs and it returns 45

 

[Allen Browne]

The Max() within the query is for choose the maximum value found in a
column. You cannot use it to select the maximum value from a list.

Try MaxOfList() from this link:
http://allenbrowne.com/func-09.html