Ranking the reults of my query/report

[NeilFrog]

Hi,

Ive produced some reports in Access. Id like to rank the results.. IE. 1, 2,
3 etc through 10.

Can anyone tell me how to add a ranking?

Thanks,

Neil

 

[Duane Hookom]

Add a text box to your detail section:

Control Source: =1
Running Sum: Over Group

 

[NeilFrog]

Thanks Duana, This works well. However, i cannot filter on this as its is at
report level.

I need to to filter records 1 - 10. Any ideas???

 

[Duane Hookom]

You can add code to the On Format event of the detail section:

Cancel = (Me.txtRankControlName >10)

 

[NeilFrog]

Thanks Duane

You can add code to the On Format event of the detail section:

Cancel = (Me.txtRankControlName >10)