Link to home
Start Free TrialLog in
Avatar of Karl001
Karl001Flag for Canada

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karl001

ASKER

Thanks very much