Yes the Sum statement is doing what I want. Now all I need to do is subtract the sum of frozen and unbudgeted from total position and i've got it

SELECT...

Rob

In the select statement I am getting count columns for total vacant, and filled. I added two new flags to the table as to whether a position is frozen or...