Hi all members,
In access how should write the MIN() function
In my table hra=5000,cca=6500,total=11500
now i want minimum of above table
in excel MIN(hra,cca,total)
Answer is hra
so please how should write the function of MIN() in access



Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer

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"