Percentages Total

[zufie]

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

 

[KARL DEWEY]

Do not total the percentages. Sum the numbers used to derive the
percentages and then do a percent.

 

[zufie]

Do not total the percentages.   Sum the numbers used to derive the
percentages and then do a percent.

--
Build a little, test a little.

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
.- Hide quoted text -

- Show quoted text -

Good idea. However, the end users want a percentage at the end of each
row. I will check with the users and see if this is still important.
Thank you. Zuf

 

[KARL DEWEY]

I did not say to remove the percentage displayed at the end of each row.
I said to not total those percentages but use the raw data for total percent.
--
Build a little, test a little.

Do not total the percentages. Sum the numbers used to derive the
percentages and then do a percent.

--
Build a little, test a little.

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
.- Hide quoted text -

- Show quoted text -

Good idea. However, the end users want a percentage at the end of each
row. I will check with the users and see if this is still important.
Thank you. Zuf
.