[RESOLVED] Access report: only show the first xx number of records

[Redmar]

I have a very simple issue, so maybe it is also very easy to solve, but I could not find a way to solve it...

I have a report that displays lets say a few hundred records. I have sorted the records on a specific field and now I want to display only the first 15 records.

Is there a method to stop displaying the records after the 15th record is displayed?

[brucevde]

Is your report based on a query? If yes it could include the Top clause.

Select Top 15 ...

[Redmar]

Thanks, that was exactly what I was looking for! I didn't know about the Top clause before. A handy one!