Ranking the reults of my query/report

N

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
 
D

Duane Hookom

Add a text box to your detail section:

Control Source: =1
Running Sum: Over Group
 
N

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???
 
D

Duane Hookom

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

Cancel = (Me.txtRankControlName >10)
 
Top