I am using the following code to read a sub set of records from the data table. I need to find the minimun and maximum values of Xdim and Ydim. How can I use the Dmin and Dmax functions to find the Minimum and Maximum value for the values for variable rs(2) and variable rs(3)?
SQL = "SELECT ID, GroupID, XDim, YDim FROM DimensionsTable WHERE (((GroupID)=1)); "
Set rs = db.OpenRecordset(SQL)
X1 = rs(2)
Y1 = rs(3)
Thanks
Lynn Sipes
SQL = "SELECT ID, GroupID, XDim, YDim FROM DimensionsTable WHERE (((GroupID)=1)); "
Set rs = db.OpenRecordset(SQL)
X1 = rs(2)
Y1 = rs(3)
Thanks
Lynn Sipes