1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
Public Function Test1(ByVal A As Double, ByVal B As Double) As Double
Dim Res As Double
If A > 0.25 And A <= 4 And B > -6 And B <= 6 Then
Res = 100
ElseIf A > 4 And A <= 7 And B > 6 And B <= 9 Then
Res = 200
End If
Test1 = Res
End Function
Public Function Test2(ByVal A As Double, ByVal B As Double) As Double
Dim Res As Double, i As Long, c As Variant
c = Array(0.25, 4, -6, 6, 100, 4, 7, 6, 9, 200)
For i = LBound(c) To UBound(c) Step 5
If A > c(i) And A <= c(i + 1) And B > c(i + 2) And B <= c(i + 3) Then
Res = c(i + 4)
Exit For
End If
Next i
Test2 = Res
End Function
Public Function Test3(ByVal A As Double, ByVal B As Double) As Double
Dim Rs As DAO.Recordset
Set Rs = CurrentDb.OpenRecordset("SELECT C FROM tTEST WHERE " & A & ">AMin AND " & A & "<=AMax AND " & B & ">BMin AND " & B & "<=BMax", dbOpenSnapshot)
If Not Rs.EOF Then Test3 = Rs!c
Rs.Close
Set Rs = Nothing
End Function |
Partager