Auto top 10 in report

[nickbolt]

Hello,

I am a beginner in Access and i like to know if someone knows how to
make an automatical top 10.
example:

1 .......
2 .......
3 .......
4 .......
5 .......

what i want to know is how to get automatically the numers 1 / 10.
is there a special expression?

Many thanks in advance.

Nick

 

[Duane Hookom]

Add a text box to your detail section:
Name: txtCount
Control Source: =1
Running Sum: Over All
If you want to only print 10 records, add this code to the On Format event
of the detail section:

Cancel = Me.txtCount >10

 

[Nick Bolt]

I tworks fine now...

thank you very much


Duane Hookom schreef: