How to return the max value from expression-list?

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.
.

Relevant Pages

  • Re: How to return the max value from expression-list?
    ... MadCityRock wrote: ... > 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, ... Aggregate queries in a database work against *rows* not a series of ...
    (microsoft.public.access.queries)
  • RE: How to compare fields
    ... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Column headers for exported data
    ... is that the numeric fields do not export alphanumeric ... exporting, I end up getting a blank in the export. ... Sam ... Prev by Date: ...
    (comp.databases.filemaker)
  • RE: Default Value from last record in table
    ... By the way, my field is CURRENCY. ... I found here a solution for TEXT and COMBO BOX but not for numeric fields ... > Does anyone have a better suggestion? ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: counting records
    ... > I have a table with one numeric fields. ... > i want to add a record number field in a query ... Hi Pierre, ... Prev by Date: ...
    (microsoft.public.access.queries)