I'm very new to most SQL, VB, etc. and I think this is pretty simple so I
hope someone can help!!!
I have a database that I store all of my research data in, then I query it
in Excel to do analysis. I've put in a function that I found from the
Microsoft KnowledgeBase to find the minimum value across various fields in
ONE record. However, when I try to query the database now it gives me a
"Undefined function in expression" message.
I've read around and now realize that the modules aren't part of the
Microsoft Jet Database (or something like that!!) and thus cannot be seen.
I've also read that the likely solution is to use SQL to do the same thing,
unfortunately I'm having trouble finding any resource that will explain SQL
at my level!!!!
Can anyone help me write the same function in SQL??? Below is the code that
I was using. Thank you so much in advance.
Oggie
Function Minimum(ParamArray FieldArray() As Variant)
' Declare the two local variables.
Dim I As Integer
Dim currentVal As Variant
' Set the variable currentVal equal to the array of values.
currentVal = FieldArray(0)
' Cycle through each value from the row to find the smallest.
For I = 0 To UBound(FieldArray)
If FieldArray(I) < currentVal Then
currentVal = FieldArray(I)
End If
Next I
' Return the minimum value found.
Minimum = currentVal
End Function
Bookmarks