I am facing an error. Using MS Access 2013
Module Code:
Public Function CalcVal(pvVal1, pvVal2, pvVal3)
Select Case True
Case pvVal3 >= 9
'add up in Value_2 and the Value_3 should be <9
If (pvVal2 + pvVal3) < 9 Then
CalcVal = pvVal2 + pvVal3
Else...
Hi Everyone.
Can anyone please help me?
I have MS Access Database 2013 (ver)
Tbl Fields
Field_1
Field_2
Field_3
I want to calculate these fields like
Field_3/9 then the answer Add/plus in Field_2 (Field_3 should be less then 9 always)
Field_2/20 then the answer add/plus in Field_1...