Question Locked

Access count function

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.