I have a table database (FM 5) in which I am recording a series of anatomical characteristics of different teeth (I am a dentist /researcher, sorry for that). There are approx. 5000 records (total gro

[briseno]

I have a table database (FM 5) in which I am recording a series of anatomical characteristics of different teeth (I am a dentist /researcher, sorry for that). There are approx. 5000 records (total group). Some fields (non-repeating fields) are pop-up lists with specific categories. What I am trying to do is after a specific tooth (e.g. front teeth) was found is to find out how many teeth in this sub-group (count I supose) are clasified as category A, B, C etc. (from a given field) and the percentage of this category in this specific sub-group. I hope I could make myself clear enough, because I really need help.

Ben