RE: How to compare fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

Can you post the iif you used, and didn't work?

--
I hope that helped
Good luck


"Luther" wrote:

> Sorry, this did not work; It needs to return the maximum value among the 3
> fields.
> Any other ideas, please?
>
> "Ofer" wrote:
>
> > 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: Dates and Iif function in query criteria
    ... I'm not having much luck unfortunately. ... Currently your iif ... > function is evaluating your expression to see if it is ... > do it in the query all the better. ...
    (microsoft.public.access.queries)
  • Re: Why DataTable.Select("IIF(...)") is refused !
    ... Good Luck! ... "The name 'identifier' does not exist in the current context " ... Someone knows how using IIF in a DaTaTable.Select? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Select Query Question
    ... You can use DatePart with the IIF of the fields to accomplish this task. ... Good Luck ... "Karl" wrote: ...
    (microsoft.public.access.queries)
  • RE: How to compare fields
    ... "Luther" wrote: ... >> In the last selection, ... >> Good luck ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Count/Dcount and Group Header
    ... Ooops, my mistake with the first example, I forgot the IIf. ... Good Luck ... So it will sum all the 1'ns when the criteria is met ...
    (microsoft.public.access.reports)