Select top N records

[shod90]

Dear Gents,
Is there a way to let the user when he opens the report to choose top N records he wants , As an example i need him to choose the most purchased items in his store from date till date and there is a text box to enter how many records he want to see .


Is it possible ?

[CJ_London]

use the TOP element of a query

SELECT TOP 10 * FROM myTable

You will need to use VBA to build the sql string because you cannot use the 10 like a criteria. e.g.

So say you user has entered 20 in a text control called txtRecordsRequired

in the after update event of that control put

me.recordsource="SELECT TOP " & txtRecordsRequired & " * FROM myTable"

[shod90]

Silly me , The answer was very easy lol .. Thanks it works.