Re: Value over ride in Query, Choose the highest value in Query, need

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Terry wrote:
I have three field in the Query: A B and C. The table is as low

A B C D
1 2 3 3
2 2 1 2
3 1 1 3

I want an expression in query, that will allow me to have field D, which
choose the highest value among ABC fields. thanks.


You can create a function to do that. See
http://allenbrowne.com/func-09.html

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Value over ride in Query, Choose the highest value in Query, need
    ... A work around for this would be using LARGE function in Excel. ... Terry wrote: ... I have three field in the Query: ... choose the highest value among ABC fields. ...
    (microsoft.public.access.queries)
  • RE: Select Query By Month.
    ... "ORDER BY" is SQL's way of sorting. ... John H W ... "Terry" wrote: ... >> query. ...
    (microsoft.public.access.queries)
  • Re: Help with output format
    ... Starrt with a query that ... "Terry" wrote in message ... >> Check the demo download of Generic Concatenate function at ... >> Duane Hookom ...
    (microsoft.public.access.reports)
  • Re: NOT IN operator not working with subquery.
    ... >>I want to get a list of company names that we have in our database, ... >> have not ever sent an invoice to. ... Why does the following query not work? ...
    (microsoft.public.access.queries)
  • Re: subtracting one IIF from another
    ... "Terry" wrote in message ... > create another query based on the query which creates the ... > calculation. ... >>Supv creates the supv dollars. ...
    (microsoft.public.access.reports)