Min of values in two columns

[roadrunner139]

Hello,
I want to obtain the max number of columns TEST1 and TEST2

NAME    TEST1      TEST2
Joe    2    3
Jane    3    1
Bob    5    1

The outcome should look like this

NAME    TEST1      TEST2   MAX
Joe    2    3            3
Jane    3    1            3
Bob    5    1            5

I can't seem to to get a MAX when combinig two columns, please help.

Thank you in advance!

[MSeda]

Will an if statement not do?

SELECT Name, Test1, Test2, IIf([Test1]>[Test2],[Test1],[Test2]) AS [Max]
FROM [Test Table];