How to do a Percentages in reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhett_Y - 15 Sep 2005 15:33 GMT

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

Reply to this Message

Duane Hookom - 15 Sep 2005 16:44 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> Hello all..
>
[quoted text clipped - 38 lines]
> Thanks again
> Rhett

Reply to this Message

Rhett_Y - 15 Sep 2005 18:54 GMT

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

> 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
[quoted text clipped - 42 lines]
> > Thanks again
> > Rhett

Reply to this Message

Duane Hookom - 15 Sep 2005 21:33 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> Duane...
>
[quoted text clipped - 62 lines]
>> > Thanks again
>> > Rhett

Reply to this Message