Inversing Sign for Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Access users,

How do I apply a negative sign to a number? For example, from 45 to -45.
Is there an inverse or similar function in MS Access? If not, how can I
create one?


Kind Regards
Charles
 
Just put a negative sign in front of it. Or use this function:

Public Function ReverseSignOnNumber(varNumber as Variant) As Variant
If IsNumeric(varNumber) = True Then
ReverseSignOnNumber = -varNumber
Else
ReverseSignOnNumber = varNumber
End If
End Function
 
.... or * -1


Ken Snell said:
Just put a negative sign in front of it. Or use this function:

Public Function ReverseSignOnNumber(varNumber as Variant) As Variant
If IsNumeric(varNumber) = True Then
ReverseSignOnNumber = -varNumber
Else
ReverseSignOnNumber = varNumber
End If
End Function
Click to expand...
 
Back
Top