Question Statistics form DB table

[Ammarhm]

Hi Guys
I have a medical database in which there will be tables holding about 3000 x 20 enteries (ie about 60 000 records), information will be stored like patient age, sex, diagnosis, .....
Is there a ready way to get good statistics easily form the table? t ex total patients number, mean age, how many patients in each diagnosis catogery, how many male and female patients etc...
This is very important and i really appreciate any help

 

[georgedwilkinson]

Yes, there are several aggregate functions in Access. For instance Max(), Avg(), Count(*). You can play around with the query builder to get a little better idea all the neat stuff you can do.

Give us a yell if you need help with specifics (but make sure to include the specifics).