generating statistics from table data

[access_learner]

hi guys. <<sorry if this is in the wrong place, wasnt sure>>

ive got a db running. with a form showing all the database information from my table (Students), and allowing the user to do all the update, add kinda things on it.
I want to add to this a statistic page, which i would use another form for.

Ive had a good look on google but everything comes back with website statistics etc.

Im just wondering how do i generate statistic from a single database.

eg.
in the students DB there is name, address, course blah blah blah

i want to be able to have a drop down box with a list of the fields in my DB, when the user selects the field they want (eg gender, age)
another box (i assume text box) would return the computed result of how many people are male and how many are female. but report this back in a %

another example if they want to find what level of high school students have completed. they select the completed high school field from the drop down box then a text field or something similar says:
Y10 %10
Y11 %30
Y12 %30
Y13 %15
Not completed %5


so yea..hopefully i made it clear what im trying to do.

thanks for any help.

 

[Jon K]

I have attached a sample database. When you select a field in the combo box on the form, the relevant percentages will be displayed in the list box.

The code used is in the After Update Event of the combo box. You may need to modify the code to suit your needs.
.

 

[access_learner]

great thanks for the database.

I didnt expect a complete working sample.
cant wait to incorporate this into my form.
Thanks alot man

cheers.

access_learner