calculate percentages

[ctls]

Hi,

I am hoping somebody could help me out here.

I have an Evaluation table. The table consists of fields - Job Title, Department, Years of Experience etc. In my layout, I want to be able to choose a particular Job Title, say "Professor" and find the percentage of Professor records. And similarly for Department. If I choose "English" Department, I want to get the percentage of English department records.

This is my first step. My next step is to choose "Professor" and "English" department and find percentage records with Professors from English department. I hope somebody can help me out here.

Thanks in advance.

[Matthew F]

O.K. Here's a simple minded solution. I created two tables one with the staff listing and the field names that you gave. The second is an analysis table with match fields for Department and Job Title, plus a calculation field for the percentage. There is a multicriteria relationship between the two tables using both the Title and Department names. The trick here is that I included the entry "Any" as a second line item for each of the Department names and Titles so they would not be excluded from the relationship if this field has no entry in the Analysis table.

At least it works... See the attached file for more details.

[ctls]

Hey,

Thanks for the help.

Prithvi