Windsor302
Registered User.
- Local time
- Today, 07:01
- Joined
- Jul 13, 2011
- Messages
- 56
Hey guys, I am first going to explain what I am trying to achieve then tell you what I have, Tasks are performed by multiple People, overall 20% of each Persons Tasks has to be tested. However the Tests have Categories (qualifier 1 and 2, original, repair, rework etc..) and the first 2 (qualifiers) do not count towards the percantage. I currently have a query that counts the number Tasks performed by each Person and the total number of Tests that were done, how can i get it to only count the Original and Rework Categories. Thanks a lot.
