Re: How to return the max value from expression-list?

Tech-Archive recommends: Fix windows errors by optimizing your registry

In addition to Rick's solutions, you could consider setting a Reference to
Excel's object model, and using the Excel function in code.

Good luck

Jeff Boyce
<Access MVP>

"MadCityRock" <MadCityRock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12F6E1D4-E568-4AAD-8869-3EFBD5D508B9@xxxxxxxxxxxxxxxx
> In an Access 2003 SQL Select-query, I want to put the max of a list of
> numeric fields from each table row into a new variable, eg:
> SELECT ...
> Max(Field1, Feld2, Field3, Field4) as GreatestVal
> FROM ...
>
> I seem to recall that this non-aggregate Max function worked in earlier
> versions of Access, but now errs as having the wrong number of arguments.


.