Jamie --

   I like the approach because of its simplicity; however, if the records are numbered in the order that they appear in the table. This may be good...

Ray - Thanks, I am doing that now but the problem is that we will need this capability in our next data release.

Thanks

Gary, In general I would do the same thing. However, in this instance the data that the users will be using has suppression rules and the numbers that are...

This is all very helpful. I was just wondering if there is a way that this can be done in a query like one would create a SUM (see...