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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.