I have a field in a straight Table that holds the type of a Transaction. The are two types: A and K. Each type holds a date which can be the same (meaning that on 16/09/2010 we can can have both A and K) and a ranking (calculated as an expression). To the problem now: what I want is to count how many 'A' there are between two 'K', and use that as an expression in the straight table. Thus I want to find the next same 'K' for example and then count Type substracting it by 2 in order to get the count of 'A' . Can anyone shed some light to my problem??
