SORTING

[TheBeginner]

Hey, i need some help. I am setting up a query in access that requires me to output the average of a set of figures. what i want to do is output the average of the following figures: 11,12,14,18,22. at the moment the query i have setup output the average of these figures which is 15.4.

but i want the average of how many times each of these figures occurs in that table. ie how 11 occurs 3 times, 12 occurs 10 times etc... how do i do this ????

p.s im not very technical so please make the answers idiot proof!!

 

[jason246day]

Please provide some more information about your data. Like what your attribute names are, and anything else that you thing would give me a better idea of your setup.

 

[TheBeginner]

well, i have a members table. withing this table holds all the members details. one of the details is the ethnic origin of the member. this is identified by a code. in this case the codes start from 11,12,14,18,22.

i would like to create a query that enables me to view how many people of a particular ethinc group there are. the original post explains the rest on how i want ot output the data.

 

[jason246day]

SELECT ethnicity, Count(ethnicity)
FROM members
GROUP BY ethnicity;

Try this bad boy out and let me know if it gets her done.