This has me stumped.
I am working with an existing DB for tracking software bugs. In it,
there is a repeating number field for the software version. This may
look something like 1,2,3,etc.
I have designed a "report" that generates stats for each day based on
several find requests. All the other stats work wonderfully, but the
one for bugs that are open but regressed does not.
The bugs I need found have 1) a status of "open" 2) include the
latest version number in the repeating number field (but NOT in the
The problem: the find will also turn up new bugs written that day,
i.e. the first repetition.
I need it to find the current version number NOT in the first
repetition. But it could be in one of up to ten repetitions.
Does this make any sense at all? Please help if possible!
Forgive my jumbled explanation.