Hi Inge,

Why don't you normilize your data:

Entry Tn Goal
1     10 5       
1     4  6    
1     33 7      
2     55 2  
2     77 3  
2     8  4
3     21 9      
3     14 10       
3     1  11  

Now your select would be realy simple

SELECT Tn, Goal From Mytable ;
  WHERE Tn In ( SELECT Max(Tn) From Mytable)

>t1,t2,t3,goal1,goal2,goal3
>10,4,33,5,6,7
>55,77,8,2,3,4
>21,14,1,9,10,11
>
>1st record: maximum=33
>2nd record: maximum=77
>3rd record: maximum=21
>I need the maximum of these 3 records (maximum of 33,77 & 21) = 77
>(maximum of t1, t2 or t3 of all the records),
>PLUS the corresponding goal. For this example, it would be goal2=2.
>(t1 corresponds to goal1, t2 corresponds to goal2, etc.)
>
>SELECT MAX(IIF(t1>t2,IIF(t1>t3,t1,t3),IIF(t2>t3,t2,t3))) as xRet from table1
>This gives me the max. of t1,t2, & t3 of all the records (thanks for all your help to come up with this one),
>but how do I get the corresponding goal from the corresponding record??
>
>THANK YOU ALL!