>t1, t2, t3
>10, 15, 7
>12, 6, 8
>5, 4, 11
>1st record: maximum=15
>2nd record: maximum=12
>3rd record: maximum=11
>I need the maximum of these 3 records (maximum of 15, 12 & 11) = 15.
>I guess what I need is the maximum of t1, t2 or t3 of all the records.
>
>SELECT IIF(t1>t2,IIF(t1>t3,t1,t3),IIF(t2>t3,t2,t3)) as xRet from table1
>This only gives the maximum of t1, t2 or t3 per record.
>How do I get the maximum of that maximum?
>
>Thank you all!
In two steps: firstly select max per each record, then calculate final max.
You probably can use UDF and one select, but I doubt, you will have reliable results...
If it's not broken, fix it until it is.
My Blog