[RESOLVED] Access report: only show the first xx number of records
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?
Re: Access report: only show the first xx number of records
Is your report based on a query? If yes it could include the Top clause.
Select Top 15 ...
Re: Access report: only show the first xx number of records
Thanks, that was exactly what I was looking for! I didn't know about the Top clause before. A handy one!