Ranking the reults of my query/report

  • Thread starter Thread starter NeilFrog
  • Start date Start date
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
 
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???
 
You can add code to the On Format event of the detail section:

Cancel = (Me.txtRankControlName >10)
 
Back
Top