Is there any possible way to do it at all though? I want to be able to sum up
how many total available openings that each school has and show it on my
table. I'd rather have it in my table then a report.

Another totally different question....When I create a query does it automa.
update itself if the main table is updated to fit the criteria of the query?
for instace, In my main table i have a status for each one of my candidate -
Hired or Not Hired. In my query I have it to where it should show all the
persons that are the status=hired. But as time goes on I will change (update)
the status of some to equal to "Hired" and wish for that person to show up in
my query. This should be possible right?

Thanks a bunch! ~Hillary