How can I do operations with recordset columns, for instance I have the following code


rsR.Open "SELECT resistance FROM [compilation$B6:C32450]", con
rsX.Open "SELECT reactance FROM [compilation$B6:C32450]", con

how can i calculate the following new values:

The minimum and maximum value of Z where Z is equal to: SQRT(resistance^2+reactance^2) ----> sqrt IS THE square root two