Max value from differents fields (Access table)

Hi,
Is their any function where I can have the maximum between differents fields ?
Example:

Table:
tb_Sales

Fields:
Jan_Sales = 2000
Feb_Sales= 3000
Mar_Sales=2000

In a query, is their a function like
Max(Jan_Sales,Feb_Sales, Mar_Sales)
that  will give me 3000

thanks
Karl001Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
test this

Select Max(T.Sales) as MaxSales
from
(
select Jan_Sales as Sales from tb_Sales
Union all
select Feb_Sales as Sales from tb_Sales
Union all
select Mar_Sales as Sales from tb_Sales
) as T
0
 
Karl001Author Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.