can I create a function to display the lower of two fields?

A

amyb02

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

iif([fielda]<[fieldb],[fielda],[fieldb])
you might have to be careful with null, though. Are these required fields?

-John
 
Top