seems to me this should work, but i have exactly zero experience running access queries (of which "IIF" is unique to, i believe)...keeps telling them the syntax is wrong, and it might be something obvious, but i don't see it

banana:
IIf(
    IIf(
        IIf([apple]>[pear],[apple],[pear]) AS fruit1
        >
        IIf([orange]>[kiwi],[orange],[kiwi]) AS fruit2
        ,[fruit1],[fruit2]
    ) AS fruit3
    >
    [peach],[fruit3],[peach]
)

4/25/2012 3:25:38 PM

GO BANANA

4/25/2012 3:49:03 PM

Is it the aliasing that's fucking you up?

You had to use banana: to designate the first IIF's alias, would you need to do the same with fruit1, fruit2, and fruit3?

4/25/2012 4:21:21 PM

I would think this is a much better way to go:

http://support.microsoft.com/kb/209857

4/25/2012 6:54:24 PM