I use function below, now I want to change this to select correct columm in table for calculation purposes.
Is this possible.
******************************************
Public Function RateSelector(myCheageableWeight As Double) As Double
Select Case myCheageableWeight
Case 0 To 3:
RateSelector = [tbl_GAP_Rates]![GAP1]
Case 3.00001 To 5:
RateSelector = [tbl_GAP_Rates]![GAP2]
Case 5.00001 To 10:
RateSelector = [tbl_GAP_Rates]![GAP3]
End Select
End Function
Is this possible.
******************************************
Public Function RateSelector(myCheageableWeight As Double) As Double
Select Case myCheageableWeight
Case 0 To 3:
RateSelector = [tbl_GAP_Rates]![GAP1]
Case 3.00001 To 5:
RateSelector = [tbl_GAP_Rates]![GAP2]
Case 5.00001 To 10:
RateSelector = [tbl_GAP_Rates]![GAP3]
End Select
End Function