Formula To Return Lowest Of Two Calculations

[litrelord]

Hi All,

I have a formula in Access which evaluates two options and I need to return the lowest of the two numbers e.g.

MIN(Result1/i],Result2)

I would guess I need to have the two values entered into the MIN function as an array but I've not found a way to do this (although this is probably me not searching for the correct terms).

I could write a UDF easily enough but I'd like to avoid the overhead of using VBA if possible as it always seems to slow things down too much.

Thanks

Nick

 

[Joe4]

If you are talking about doing this in a query, how about a simple IF statement?

IIF([Field1]<[Field2],[Field1],[Field2])

 

[litrelord]

If you are talking about doing this in a query, how about a simple IF statement?

IIF([Field1]<[Field2],[Field1],[Field2])

But that would be way too simple surely! :D

Not sure whey I constantly overcomplicate things but thank you, this works perfectly.

Nick