Found count in goups of nine

[rivet]

Here is my math question.

If I find a group of records I would like to count them in groups of nine. So say I find 30 records my list will return.

1 2 3 4 5 6 7 8 9, 1 2 3 4 5 6 7 8 9, 1 2 3 4 5 6 7 8 9, 1 2 3

My solution is:

Mod(Status(CurrentRecordNumber),9)

But I get a zero when it hit the multiples of 9 so with out a condition is there a clean solution so I get a 9 instead of a zero.

[ernst]

Try:

Mod(Status(CurrentRecordNumber) - 1 ,9) + 1

Ernst

[Fitch]

If (Mod(Status(CurrentRecordNumber),9), Mod(Status(CurrentRecordNumber),9), 9)

There's probably a math-wiz way to do it that's "cleaner," but it's better than nothing.

[Fitch]

I knew it! Ernst is a genius.

[rivet]

thank you - perfect