G Guest Jan 4, 2006 #1 In a query I would like a field that would show the lower of two fields, similar to the MINA function in Excel
In a query I would like a field that would show the lower of two fields, similar to the MINA function in Excel
J John Welch Jan 4, 2006 #2 iif([fielda]<[fieldb],[fielda],[fieldb]) you might have to be careful with null, though. Are these required fields? -John
iif([fielda]<[fieldb],[fielda],[fieldb]) you might have to be careful with null, though. Are these required fields? -John
