Sum based on field matches and Y or N controls

[Gray Sadler via AccessMonster.com]

What I'm trying to do is very confusing. I don't even know if I can explain
what I'm trying to do even, but here goes nothing:

I have a database that's for an insurance company, and this database serves
as a tool to use to annualize insured's reported quarterly payroll. I have
a query called qryOfficers, which is based from tblOfficers, that looks up
certain officers of a company based on the insured's ID number. The fields
in this query are:
code(duty of officer)
exempt(whether or not this officer is included on the policy)
qtr1, qtr2, qtr3, qtr4 (which are reported payrolls for each officer on a
quarterly basis)

I have a form where I input the quarterly payroll for each officer, but now
I'm trying to come up with an expression, function, or query that will
total all payroll for each class code in the query qryOfficers.

Another thing I'm trying to accomplish is determining if the reported
payroll for each officer will be included or removed from the overall total
for each class code depending on the 'Y' or 'N' field, 'exempt.

If anyone is interested, I can email my database and/or chat on aol about
it. Any help or input is greatly appreciated!

 

[Duane Hookom]

Before doing anything else, I would normalize the tables to create a
OfficePayroll table that has fields for officer, Year, Quarter, and
payrolls.