Hello everyone, and happy holidays,
I have encountered a problem and I am trying to find a work around do to time constraints. Here is the code that I am running:

strData = "Select Min(num1) as MinVal from Table1"
strReader = strCmd.ExecuteReader
While strReader.Read
varMin = strReader.Item("MinVal")
End While
strReader.Close()



When I run the code I get the IndexOutOfRange Exception. I get this exception due to the fact that Min(num1) is a negative value. It is supposed to be and will be negative the majority of the time. Does anyone know how I can get around this?