Inversing Sign for Numbers

[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

 

[Ken Snell [MVP]]

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

 

[Rob Oldfield]

.... or * -1

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

 

[Ken Snell [MVP]]

yep!

--

Ken Snell
<MS ACCESS MVP>

... or * -1