If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Getting Percentages Correct
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Getting Percentages Correct
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" wrote: 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 |
#4
|
|||
|
|||
Getting Percentages Correct
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" wrote: 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" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|