Max of different columns

J

JapanFreak

Registered User.

Local time

Today, 12:44

Joined

Aug 25, 2007

Messages

45

• Nov 30, 2008

• #1

Dear All,

I have a question: I want to have a query which gives me the maximum of different columns, i.e. somehting like Max(Column1, Column2, Column3). Due to my Google research I know that there is a function called "Greatest" in MySql - is there something similar in Access / VBA?

JapanFreak

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 03:44

Joined

Aug 30, 2003

Messages

36,269

• Nov 30, 2008

• #2

One way (there is no built-in function):

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857

 

J

JapanFreak

Registered User.

Local time

Today, 12:44

Joined

Aug 25, 2007

Messages

45

• Nov 30, 2008

• #3

Thank you, that helps!

 

apr pillai

AWF VIP

Local time

Today, 16:14

Joined

Jan 20, 2005

Messages

737

• Dec 7, 2008

• #4

I have something for you, this is not built-in function, I have created it, check this out:

http://www.msaccesstips.com/2008/11/sum-min-max-avg-paramarray.shtml