I have a query that checks whether a item was a pass or fail when it was tested, what i need is to count through the records and see what testing would be required for the next item of that type.
All new items are tested 10 times, after that it can be a 'skipped item' for 9 more, then back on to...