I have a Access dbase that tracks error by employees in a process. There are 4 position to the process. Every month we measure proformance by error rate so I need to count the number of error in the dbase by position.
I want to make a report or query that counts the error by active employees table. There are over 100 employees. I have made 4 queries that list only error in that position but when I try to get a count for each employee it does noot work. I am looking for something like countif comparing employee table against the error queries.
Example:
EMPL position1 position2
emply1 0 1
emply2 0 0
