Search results

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...