Limiting Records in Crystal Report 8.5

i have sorted the data from a MSACCESS database with a query to show the highiest score to the lowest.

how can i get only first 10 records to show in the detail section of report? its for the top ten list.

thanks.

Insert "TOP 10" after the SELECT in the SQL query.

SELECT TOP 10 * FROM YourTable

@damonous

thanks!


:)