Thread: MIN() function
View Single Post
  #2 (permalink)  
Old October 29th, 2004, 07:09 AM
JLovell JLovell is offline
Authorized User
 
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mohamed-

Access is not Excel. You can find the Min value across multiple rows, but not multiple columns - at least not using Min. To do it in Access, you have to write an ugly expression using IIf:

IIF([hra]<[cca], IIF([hra]<[total], [hra], [total]), IIF([cca]<[total], [cca], [total]))

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
Reply With Quote