>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!
If you can use an xBase rather than SQL solution perhaps
CALCULATE MAX(MAX(T1,T2,...Tn)) TO myVar
will work for you.