Different data providing different results....using if, then

[friar85]

I am a total newbie, so be easy on me.

I a running a query where an employee may make 3 different types of mistakes: adm, doc or proc. These mistakes are contained in A field called ErrType. I wan to assess the folowing points: Adm = 10 points, doc = 5 points and proc=2 points. In addition, if an employee self-reports the error (yes/no), the 2 points will be deducted. ([SelfRep],-2,0).

I want to create a query where I can pull up names of employees and have the totals calculated. Some employees may have multiple errors of varying types.

How can I get the query to calculate a) points for an individual error and b) total points accumulated by an employee?

Any suggestions are welcome. I am looking to learn to do this myself, so even just pointing me in a direction would be beneficial.

Thanks in advance!

[orange]

Please show your table designs/structures.
Please post the query sql.
Are you using lookups at the field level in a table?
If so see http://access.mvps.org/access/lookupfields.htm

General help with query
http://www.techonthenet.com/sql/select.php