Finding the MAX

[Guest]

Hi All,

Can anyone help me with an expression that I am trying to write in a query?
What I have is....Lets say....10 columns across and in those columns there
are numbers. What I would like to happen is to have an expression that will
look at all 10 columns and tell me the highest number.

Any ideas?

Thanks for any help

 

[Guest]

Hi Rockwater,

Try this KB article:

(ACC2000 How to Find Minimum or Maximum Value Across Fields of Record
http://support.microsoft.com/?id=209857

Note: I added parentheses around the "ACC2000:" part, because this KB
article should apply equally well to Access 2002 and 2003.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________