take a look at the attached database. I want to create a running sum for CommitteeID from [tbl]joinPersonnelPosition. As you can see in [frm]problem I didn't get very far...
So what I want is this: Output how many CommitteeID's there are for a certain criteria (see form) BUT within a certain year (that is what I didn't know how to implement yet).
Another thing I want to create too is text fields with the labels for the Committees taken from tblCommittees.
So what I finally want to have is frmFinal < take a look at that to see what I'M talking about.