• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

how canc i hange a positive number to negative in vba access 2010

hi

how canc i hange a positive number to negative in vba access 2010  and a negative number to a positive
0
bill201
Asked:
bill201
  • 2
1 Solution
 
RunriggerCommented:
I would say simply multiply by -1

However, you sometimes get a decimal place introduced in the calculation, so be aware of that.

If dblValue>0 Then dblValue = -1*dblValue
0
 
RunriggerCommented:
what I meant to say was that you sometimes get a decimal introduced when you multiply an Integer by -1!!!

Seems to be an ongoing bug in VB
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now