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