A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Getting Percentages Correct



 
 
Thread Tools Display Modes
  #1  
Old December 22nd, 2009, 01:10 AM posted to microsoft.public.access.reports
Bad Shot
external usenet poster
 
Posts: 2
Default 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  
Old December 22nd, 2009, 03:39 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old December 22nd, 2009, 02:59 PM posted to microsoft.public.access.reports
Bad Shot
external usenet poster
 
Posts: 2
Default 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  
Old December 22nd, 2009, 03:50 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.