Solved

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

Posted on 2012-04-01
9
235 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:J.R. Sitman
  • 4
  • 3
  • 2
9 Comments
 
LVL 29

Expert Comment

by:IrogSinta
ID: 37794102
You could just multiply the number by negative one.
For example:  Qty * -1
0
 

Author Comment

by:J.R. Sitman
ID: 37794112
In the query or on the report
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 200 total points
ID: 37794134
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:J.R. Sitman
ID: 37794465
see attachment.  on the report I get an error.
meds1.png
0
 
LVL 29

Assisted Solution

by:IrogSinta
IrogSinta earned 200 total points
ID: 37794493
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
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 50 total points
ID: 37794764
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
 
LVL 29

Expert Comment

by:IrogSinta
ID: 37794835
Looks like cactus_data gave you an even better answer.  I myself didn't realize you could simply do that.
0
 

Author Closing Comment

by:J.R. Sitman
ID: 37795904
Both solutions worked.  Thanks
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 37795935
You are welcome!

/gustav
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Programmer 14 50
update all email addresses SQL 1 24
Access: Retrieving Current Month's Orders for Invoice 6 29
Access Open Report with SQL Parameter 11 30
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question