Re: How to find Minimum of four fields

When people start talking about minimums of four fields it is often an
indication that the design is not normalised. This is often called
"commiting spread***". In a properly designed database the function Min()
would make this task easy.
One way:
lowest: IIF([a]<=[b], IIF([a]<=[c], IIF([a]<=[d], [a],[d]),IIF([c] <= [d],
[c], [d]) ......etc

another is a VB function


"galsaba" <galsaba@xxxxxxx> wrote in message
news:1166132130.669605.308720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If I tried Excel? I did not becuase I know it will work...
I need it in access as part of big application with table relations and
other features that Excel does not have.

I need it in Access

Thanks

galsaba
Jeff Boyce wrote:
If you are trying to find a minimum value across four fields, it sounds
like
you have a spread***. Have you tried using Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"galsaba" <galsaba@xxxxxxx> wrote in message
news:1166121059.297139.185330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a table with four field (column) what wil be the way to find the
minimum?
does access provide a function to do so?
does MS VBS provides?
thanks

galsaba





.

Loading