How to do a Percentages in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all..

I did a search for this, and found a couple other topics.. None of them
seemed to work for me...

Database info:
Fields:
ID=Autonumber
Date
Ethnicity
Gender
AgeGroup
Source
Notes=Misc item entered if needed.

I have the report setup so that it gives me the following layout:
Source:
Ethnicity:
Gender:
Age Group:

Example:
Source= Newspaper/inserts Source Total = 211
Ethnicty: White =50 (want % of total white's who have used the source
Newspaper/inserts)

Gender: Male
Age Group: 19-25 =24
Age Group: 25-30 =11
Etc.....
Gender: Female
Age Group: 19-25 =9
Age Group: 31-40 =1
Etc

What I would like to do is take a percetage of the ethnicity to the total
number of people who used the source... Does this make sense???

If you need any other information let me know...

Thanks again
Rhett
 
I expect this question could result in 100s of combinations of "What I would
like to do". Have you considered using an Excel Pivot table? This would
allow you to slice and dice and drag and drill to about whatever you want.
 
Duane...

Would you do this from within Access.. Or export it to Excel and do it
there?? I am not formilier with Pivot Table? If I can do this from within
Access... That would be great.. And you are right, I can see it ballooning
up into a more items...

If it is from within access can you give me description of how I would go
about doing this??

Thanks again
Rhett
 
Back
Top