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