Repeating Record Number ("variable")

[curtcarto]

Greetings:

I'm building a XC Ski Race database for a local club. Need to have results reported out for each type of race, then by gender, then by time. I have that all built, but can't seem to get the script for sub-summary to have "record" numbers start over for each type of report. I've been using the "@@" in the layout mode, but it doesn't start over for each grouping in the sub-summary part.

In other words, I want:

20K Classic

Females;

1 Name Time

2 Name Time , etc

Male

1 Name time, etc // note: I want the "place" to start over, right now it would show 3, because it's the third record.

10K Classic

Females

1 Name Time, etc. // here again, i want it to start over

All I get is 1,2 then 3,4 etc.

Is there a way to have the final output to show the "place" for each report?

Thanks!!