Statistics

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

Guest

I have a query that I need to get statistics from. I have two fields - county
and age. I need to get percentages. example would be percentage of people
in king county, pierce county, and so on. on the age I would LIKE to get
statistics like percent of people ages 18-20, 21-30, and so on. Can I do this
and if so how on earth do I do it??
thanks
D
 
Percent = Part / Whole

Percents are very easy to make with a report, and would recommend making
them there. They are a little harder with a query, due to the fact that you
have to get the whole first, then pair it with the part. I typically do
this with two queries.

The first query would devise the whole. The other queries would use the
first query and incorporate the part.
 
THANKS! I'll give it a try.

[MVP] S.Clark said:
Percent = Part / Whole

Percents are very easy to make with a report, and would recommend making
them there. They are a little harder with a query, due to the fact that you
have to get the whole first, then pair it with the part. I typically do
this with two queries.

The first query would devise the whole. The other queries would use the
first query and incorporate the part.
Click to expand...
 
Back
Top