I think I just need to do an iif(,,), I am always only comparing two numbers.
Actually that formula is a little too long and nasty, I will just do a custom function in code I think.
Eric
__
http://www.mp2kmag.com/a39--word.access.excel.mappoint.html
I'm trying to convert this nasty Excel formula into an Access query...
Is there no Access equivalent to the Excel min function? Maybe a custom function?
Eric
__
http://www.mp2kmag.com/a39--word.access.excel.mappoint.html