I have records with a bit field that are in an order how do I group them in sets of 3. For example if my first three rows have bit fields 0,1,0 I want them in set 0, the next 3 are 1,0,0 I want them in set 1. Next three are 0,0,1 and I want them in set 2.
Order is important as I'm matching against a pattern table to get an overall count of the binary patterns.
I can see that Row would help but I don't know how to make row count by 3'ss.