How to do a Percentages in reports

[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

 

[Duane Hookom]

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.

 

[Guest]

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

 

[Duane Hookom]

I would pull the records from Excel. First create a query in Access that
combines your tables into a single query and possibly renames your fields to
something more meaningful.

Then search google like
http://www.google.com/search?hl=en&q=create+an+Excel+pivot+table+from+Access
for lots of tutorials and information.