 |
|
| Computers Forum Index » Computer - Databases - MS Access » Percentage Total... |
|
Page 1 of 1 |
|
| Author |
Message |
| zufie... |
 Posted: Thu Oct 22, 2009 8:11 pm |
|
|
|
Guest
|
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John |
|
|
| Back to top |
|
|
|
| Odd... |
| Posted: Thu Oct 22, 2009 8:34 pm |
|
|
|
Guest
|
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
Quote: I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places? |
|
|
| Back to top |
|
|
|
| zufie... |
| Posted: Thu Oct 22, 2009 8:51 pm |
|
|
|
Guest
|
On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
Quote: On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number! |
|
|
| Back to top |
|
|
|
| Odd... |
| Posted: Thu Oct 22, 2009 9:08 pm |
|
|
|
Guest
|
On Oct 22, 4:51 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
Quote: On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number!- Hide quoted text -
- Show quoted text -
Try setting the Input Mask |
|
|
| Back to top |
|
|
|
| Salad... |
| Posted: Fri Oct 23, 2009 1:01 am |
|
|
|
Guest
|
zufie wrote:
Quote: On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number!
Why not just create a text box with the default value of 100? Do you
ever expect it to not be 100%? |
|
|
| Back to top |
|
|
|
| zufie... |
| Posted: Fri Oct 23, 2009 1:30 pm |
|
|
|
Guest
|
On Oct 22, 4:01 pm, Salad <o... at (no spam) vinegar.com> wrote:
Quote: zufie wrote:
On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number!
Why not just create a text box with the default value of 100? Do you
ever expect it to not be 100%?- Hide quoted text -
- Show quoted text -
No. However, presently I the percentage total is more than 100%. |
|
|
| Back to top |
|
|
|
| zufie... |
| Posted: Fri Oct 23, 2009 3:54 pm |
|
|
|
Guest
|
On Oct 22, 4:08 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
Quote: On Oct 22, 4:51 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number!- Hide quoted text -
- Show quoted text -
Try setting the Input Mask- Hide quoted text -
- Show quoted text -
Thanks for the suggestion, however changing this does not help |
|
|
| Back to top |
|
|
|
| Salad... |
| Posted: Fri Oct 23, 2009 8:19 pm |
|
|
|
Guest
|
zufie wrote:
Quote: On Oct 22, 4:01 pm, Salad <o... at (no spam) vinegar.com> wrote:
zufie wrote:
On Oct 22, 3:34 pm, Odd <audrey.... at (no spam) gmail.com> wrote:
On Oct 22, 4:11 pm, zufie <john.marru... at (no spam) illinois.gov> wrote:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Is the Percentages Total textbox set to allow decimal places?- Hide quoted text -
- Show quoted text -
No. I tried setting this to 1 and also 2 decimal places, but it still
returns 100%, a whole number!
Why not just create a text box with the default value of 100? Do you
ever expect it to not be 100%?- Hide quoted text -
- Show quoted text -
No. However, presently I the percentage total is more than 100%.
If the value was 1.16 and you display 1 decimal, it'd be 1.2. If it
were 1.14, it'd be 1.1. A value could be also 1.150000001. So getting
them to total exactly to 100 may be asking much.
Maybe you can do some conversion and remove extra numbers
d = 1.345
d = cdec(left(cstr(d),3))
? d
1.3 |
|
|
| Back to top |
|
|
|
| paii, Ron... |
| Posted: Fri Oct 23, 2009 8:33 pm |
|
|
|
Guest
|
"zufie" <john.marruffo at (no spam) illinois.gov> wrote in message
news:515ddf8b-c2ba-42b1-8fe8-fd360a815f40 at (no spam) e18g2000vbe.googlegroups.com...
Quote: I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
Because you are adding floating point numbers, you cannot accurately add
percentages.
Try adding the counts and dividing by the total.
=([Count less than high school]+[Count High School Graduate]+[Count Some
College/Voc/Trade School]+[Count Trade/Voc Graduate]+[Count College
Graduate]+[Count Graduate Degrees]+[Count Other Education]+[Count No
Response Education]) / [Count of all Responses] |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Dec 11, 2009 12:22 pm
|
|