Getting Percentages Correct
You stated: "The page footer give the the total count of all 6 groups. Again:
=SUM([total #]) it to provides me a correct over all total" This must be the
Report Footer since it would not work as stated in a "page footer".
Then you state: "In the footer, I'm trying to find the percentage of each of
the total" but don't state which footer(s). A report can have 12 footers.
What exactly are you looking for? A percent in each of the ethnicity group
footers or all percentages of all ethnicities in the Report Footer?
--
Duane Hookom
Microsoft Access MVP
"Bad Shot" wrote:
I have a datebase that tracks race/enthnicity by number of people in a
household.
ie Caucasian/White 3
In my report I have a header/footer for each Race (total 6) Grouping with
the control source [Race_Ethnicity] and get the totals in the footer:
=SUM([total #]) Which are all correct. All other fields are hidden.
The page footer give the the total count of all 6 groups. Again: =SUM([total
#]) it to provides me a correct over all total same Control Source:
[Race_Ethnicity]
In the footer, I'm trying to find the percentage of each of the total. No
matter what I do I get all sorts of weird percentages.
Thanks in Advance for your Help! Vince
|