Minimum of two or more fields

[Natasha]

Hi there,

I have a query in that has one row in each column, and I
need to find the minimum result from two or more columns
in another query. Does anyone know how to do this? I've
considered trying to get all the required fields under the
one column but it isn't viable.

Thanks,
Natasha.

 

[Michel Walsh]

Hi,


That is the way to proceed, to have the values under the same column.
Note that this arrangement is the right way for computation, but probably
very wrong for presentation, but presentation are done through FORMs, not
through TABLEs. Tables should be designed to make the work easy, Forms
should be designed to make the consultation easy. You are not in Excel to be
"canned" with the data disposition in a grid, turn that to your advantage.
Anyhow, if you need the max between f1 and f2, someone can do:

iif( nz(f1, f2) > nz(f2, f1), nz(f1, f2), nz(f2, f1) )


if you do not have to deal with Null, then just:

iif ( f1>f2, f1, f2)



Hoping it may help,
Vanderghast, Access MVP