Getting Percentages Correct

[Bad Shot]

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

 

[Duane Hookom]

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?

 

[Bad Shot]

Duane;

Your correct, my mistake
This may be a second answer to your queston. Not sure the first posted.
I have 6 groups one for each race type. The group footer give me the total
people in that race.

The report footer gives me the total number of people of all races.
I need to find the percentage of each race group.

Thanks
Vince

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

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

 

[Duane Hookom]

You still didn't answer "A percent in each of the ethnicity group footers or
all percentages of all ethnicities in the Report Footer?"

If you want 6 percentages in the Report Footer than you must use a
subreport based on a totals query. If you want a percent in each group
footer, use a text box with the following control source:
=SUM([total #])/[NameOfTextBoxFromReportFooter]

--
Duane Hookom
Microsoft Access MVP

Duane;

Your correct, my mistake
This may be a second answer to your queston. Not sure the first posted.
I have 6 groups one for each race type. The group footer give me the total
people in that race.

The report footer gives me the total number of people of all races.
I need to find the percentage of each race group.

Thanks
Vince

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

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