Getting Percentages Correct

  • Thread starter Thread starter Bad Shot
  • Start date Start date
B

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
 
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;

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


Duane Hookom said:
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 said:
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
Click to expand...
Click to expand...
 
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


Bad Shot said:
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


Duane Hookom said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top