Maximum of three fields.

[Veti]

I have to develop a query which does a maximum across three columns an
use it for a calculation.

in excel this can be easily done by using the max(1,2,3) but in acces
max is for a column and not multi columns

 

[hcj]

Hi Veti,
Try:
MaxABC: IIf([a]> And [a]>[c],[a],IIf(>[a] And >
[c],,[c]))