Recent content by jcuellar8

Thank you. Your correction to my logic was right on. We are testing the data now, but from a cursory review it looks to be doing exactly what we wanted. I'll let you know if we find any problem, but thank you so much! :)

I have three columns with numerical values. I need the middle value, unless one or more of them is zero. If one is zero, I need the mimum value of the remaining two, if two are zero, I need the remaining value, if all three are zero, I need zero. I've only written queries in design view, so I'd...