I need a query to get a quantity number.
the table has 6 quantity fields
Qty Qty1 Qty2 Qty3 Qty4 Qty5
I need to find the quantity number among Qty1 to Qty5 which is closer to QTY and add another column for CloserQty to the table.
Qty Qty1 Qty2 Qty3 Qty4 Qty5 closerQty
100 500 400 50 962 110 110