How do you change a positive number in Access to a negative or visa versa

On my report, the items that were used show as a positive and the items that were received show as a negative.  See attachment.  How do I reverse these so the items used show as the negative and received as the positive.  This is Access 2007
meds.png
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
IrogSintaCommented:
Either will work but if you are using the query somewhere else as well and you don't need the numbers manipulated there then just do it in the text box of your report.  Just be sure to include the equal sign in the text box as in = Qty * -1.
0
 
IrogSintaCommented:
You could just multiply the number by negative one.
For example:  Qty * -1
0
 
J.R. SitmanIT DirectorAuthor Commented:
In the query or on the report
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
J.R. SitmanIT DirectorAuthor Commented:
see attachment.  on the report I get an error.
meds1.png
0
 
IrogSintaCommented:
Oops, in this instance it's confused between the name of your text box and the column name.  Just rename your text box to something like txtQuantity and you'll be set.
0
 
Gustav BrockCIOCommented:
Seems like you have forgotten your lower school math introducing plus and minus ....

If you currently have a textbox named Qty bound to table field Qty, rename the textbox to txtQty and bind it to:

=-[Qty]

/gustav
0
 
IrogSintaCommented:
Looks like cactus_data gave you an even better answer.  I myself didn't realize you could simply do that.
0
 
J.R. SitmanIT DirectorAuthor Commented:
Both solutions worked.  Thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.