RE: How to compare fields

I would like to know the answer to this question also, if you'll get no
better answer, try this

IIF(IIF(Field1>Field2,Field1,Field2)<Field3,Field3,IIF(Field1>Field2,Field1,Field2)))

--
I hope that helped
Good luck


"Luther" wrote:

> Hi,
>
> I need to compare three numeric fields and pick the greater of the three; I
> will then have to use that number in subsequent calculations.
>
> Any help with this will be greatly appreciated.
>
> Thanks.
.

Relevant Pages

  • 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: 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)
  • 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: How to compare fields
    ... "Ofer" wrote: ... >> 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: How to properly reply to this newsgroup?
    ... Good luck. ... > I notice that some replies appear underneath the questions. ... Prev by Date: ...
    (rec.woodworking)