Count Matching and Use other Field

[birth23]

Hi, I need help with making a query

I currently have

Items: Area: percent/item


item1 Area1 xx
item 2 Area2 xx
item3 Area1 xx
item4 Area2 xx
...
I am looking to make a query to recognize the different areas and add all the percent/item at those areas, and compute the percentage per area
so a formula to count ((the percent/item per area) / (#of Area)) *100

So looking for a way to code so i could make it recognize the items in same areas, and count the percentage of each item in those areas, and then calculate the percentage for that all area that is completed

[ranman256]

Make a query, Q1, to count the totals of each area.
then make query,Q2, using Q1 to calculate avg.