Horizontal MAX

[bodylojohn]

I have a query that looks like this:

TeamAway TeamHome Jury
---3----------6--------4
---9----------4--------2
---7----------8--------3
---2----------3--------4

How do I get a horizontal max so my query looks like this:

TeamAway TeamHome Jury Winner
---3----------6--------4--TeamHome
---9----------4--------2--TeamAway
---7----------8--------3--TeamHome
---2----------3--------4--Jury

 

[bodylojohn]

Solved it with an iif statement.

 

[bodylojohn]

Solved it with an iif statement

 

[namliam]

If you have a KEY to each line you could also use a Union query...

Also have you taken into account a draw?? Could that happen?