Limiting Records in Crystal Report 8.5

[sam22]

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.

[damonous]

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

SELECT TOP 10 * FROM YourTable

[sam22]

@damonous

thanks!