Skip a row number based on a value

[rankhornjp]

I have a report that is set up to count students in a class. Looks like this:

# Student Cert #
1 John Smith 12340
2 Joe Jones 12341
3 VOID 12342
4 James Adams 12343
5 Tom Arnold 12344



I want it to do this:

# Student Cert #
1 John Smith 12340
2 Joe Jones 12341
VOID 12342
3 James Adams 12343
4 Tom Arnold 12344


The row number is just a text box (=1) with the running sum turned on.

On this report I have to report all the certificates used for this class, in order. So I can't put the voided ones at the bottom.

I tried an IIF statement in the text box =iif([student]="VOID", "", 1)
This skips the VOIDs but starts over at 1 (no matter if it is set to "over group" or "over all"):

# Student Cert #
1 John Smith 12340
2 Joe Jones 12341
VOID 12342
1 James Adams 12343
2 Tom Arnold 12344



Any suggestions?

[NTC]

this best belongs in the Reports area.

there is no solution when using the number feature of the Report object. you would have to consider applying the numbering as part of the record set (query).

sorry not to be more helpful.

[rankhornjp]

Thought that's where I put it....

I put it there now.

THanks for the heads up