RE: How to compare fields

I would like to know the answer to that question also, if you get no better
answer you can use the long way

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

--
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)
  • 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 compare fields
    ... Good luck ... > 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: - Does Steph have a "real" job?
    ... > number and one time I believe somebody ask the contestants to compare ... Actually it was Greg who asked them to pick a number, ... Prev by Date: ...
    (alt.tv.survivor)