Threshold table

Question

I have a threshold table in access    basically if the ecount value greater than the threshold value , then tests fail or if the ecount less than or equal to the threshold value tests past.
I know how to  get the row and determine if a tests pass or fail, my problem is what is the best way to enumerate through the list or dictionary to count or keep count of each tag that occur
so I can verify against the threshold table, what should I do. So I already have a list populated in memory with all the codes that occur, the hard part how to process the count in memory so by a tests, then once i have the count I can say find this code in the table below and compare it to the threshold value





table

testName        code           threshold value             ecount            status

apple               001                      0                              2                  fail
 
apple               002                      1                               1                 pass

apple               003                      1                              0                  pass

orange            001                      1                              0                   pass

orange            002                      0                              1                   fail

orange            003                      0                              1                   fail

rice                 001                       0                             0                    pass

rice                 002                       1                              1                   pass

rice                 003                      0                              0                     pass