If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get Access to show percentages without the "-" sign?
I want percentages derived through a query and used in a report to show as
positive numbers. Access always displays percentages and negatives. how do I change this? |
#2
|
|||
|
|||
There is, to the best of my knowledge, no known issue that would cause
Access to do this unless there is some error in the calculation. If you can provide more information about how you are calculating percentages, perhaps someone may be able to see what the problem is. I suppose if you're convinced that the result is otherwise correct, you could use the Abs() function to convert the negative value to its absolute value, but I would not recommend it - it would be better to determine what the underlying problem is. -- Brendan Reynolds (MVP) "Rennie" wrote in message ... I want percentages derived through a query and used in a report to show as positive numbers. Access always displays percentages and negatives. how do I change this? |
#3
|
|||
|
|||
I'm using a yes/no in the table (the form for data entry is a simple
checklist). In the query on which the report is based I draw a percentage of items checked for each group (I'm monitoring the completeness of submittals from our sales force). For instance, a certain bit of info is either there or it is not. If the salesman gets a check mark only 50% of the time the query counts up the yes/no answers and spits out -50%. The minus sign carries over into the report. I hope that's clear - I'n not finding it to be the easiest thing to describe! Thanks. "Brendan Reynolds" wrote: There is, to the best of my knowledge, no known issue that would cause Access to do this unless there is some error in the calculation. If you can provide more information about how you are calculating percentages, perhaps someone may be able to see what the problem is. I suppose if you're convinced that the result is otherwise correct, you could use the Abs() function to convert the negative value to its absolute value, but I would not recommend it - it would be better to determine what the underlying problem is. -- Brendan Reynolds (MVP) "Rennie" wrote in message ... I want percentages derived through a query and used in a report to show as positive numbers. Access always displays percentages and negatives. how do I change this? |
#4
|
|||
|
|||
In the query which supports the form/report, change the field that contains
the yes/no data to IIf([MyYesNoField] = -1, 1, 0). This way, you'll get a postive number instead of a negative number. Linda "Rennie" wrote in message news I'm using a yes/no in the table (the form for data entry is a simple checklist). In the query on which the report is based I draw a percentage of items checked for each group (I'm monitoring the completeness of submittals from our sales force). For instance, a certain bit of info is either there or it is not. If the salesman gets a check mark only 50% of the time the query counts up the yes/no answers and spits out -50%. The minus sign carries over into the report. I hope that's clear - I'n not finding it to be the easiest thing to describe! Thanks. "Brendan Reynolds" wrote: There is, to the best of my knowledge, no known issue that would cause Access to do this unless there is some error in the calculation. If you can provide more information about how you are calculating percentages, perhaps someone may be able to see what the problem is. I suppose if you're convinced that the result is otherwise correct, you could use the Abs() function to convert the negative value to its absolute value, but I would not recommend it - it would be better to determine what the underlying problem is. -- Brendan Reynolds (MVP) "Rennie" wrote in message ... I want percentages derived through a query and used in a report to show as positive numbers. Access always displays percentages and negatives. how do I change this? |
#5
|
|||
|
|||
Internally, a Yes/No field stores the values -1 for True, and 0 for False,
so if you sum them, you'll get negative values (-1 + -1 = -2). You could try Linda's suggestion using IIf(), or you could use the Abs() function (Abs(-1) = 1) or if you may be able to use Count() instead of Sum(). For example, using the Products table from the Northwind sample database as an example, this query returns -8 ... SELECT Sum(Discontinued) AS SumOfDiscontinued FROM Products WHERE Discontinued = True .... but this query returns 8 ... SELECT Count(Discontinued) AS CountOfDiscontinued FROM Products WHERE Discontinued = True -- Brendan Reynolds (MVP) "Rennie" wrote in message news I'm using a yes/no in the table (the form for data entry is a simple checklist). In the query on which the report is based I draw a percentage of items checked for each group (I'm monitoring the completeness of submittals from our sales force). For instance, a certain bit of info is either there or it is not. If the salesman gets a check mark only 50% of the time the query counts up the yes/no answers and spits out -50%. The minus sign carries over into the report. I hope that's clear - I'n not finding it to be the easiest thing to describe! Thanks. "Brendan Reynolds" wrote: There is, to the best of my knowledge, no known issue that would cause Access to do this unless there is some error in the calculation. If you can provide more information about how you are calculating percentages, perhaps someone may be able to see what the problem is. I suppose if you're convinced that the result is otherwise correct, you could use the Abs() function to convert the negative value to its absolute value, but I would not recommend it - it would be better to determine what the underlying problem is. -- Brendan Reynolds (MVP) "Rennie" wrote in message ... I want percentages derived through a query and used in a report to show as positive numbers. Access always displays percentages and negatives. how do I change this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
.ADP SQL TABLES SHOW IN ACCESS BUT SOME WILL NOT SHOW RECORDS | Derek Walton | General Discussion | 3 | February 11th, 2005 05:03 PM |
MICROSOFT INVESTING HEAVILY IN ACCESS | Mike Painter | General Discussion | 39 | October 15th, 2004 03:56 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |