Please Help - Pivot Table Trouble

J

jschping

Hi,

I have a table where I have lists of colleges that my students have applied
to as well as their status. The table has fields for student ID (foreign key
to the students table), the name of the college, (not normal form, I know),
and 3 boolean fields, for "Accepted", "Wait_List", and "Going." I keep them
separate because they might overlap.

I created a query to join the two tables so I get the student's names, the
colleges they applied to and their status. In the query I create one field
called "Status" which combined the 3 boolean fields.

I also created a pivot table off the query. The rows are the college names,
and the columns are the status's. That works fine. I get the list of students
for each college. I also calculate totals for each column.

I want to also get the averages for each college, to know what percent of
our students who applied got accepted, wait-listed, rejected, etc. I would
calculate the [Total Accepted] / [Grand Total] for each college. But I have
NO IDEA how to reference those calculated totals.

I guess I could go back and make separate fields in my original query to do
that, but isn't there a simpler way?

Thanks!!

jschping
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top