By creating a Query based on your table, and selecting a certain
number of fields and applying criteria to select the record.

If you would like a more detailed or clearer answer, please post a
more detailed and clearer question.

                 John W. Vinson[MVP]    

If I understand your question than first you have to
filter your query with the criteria you want, and if then
you got 100 records but you want to display only 10
records than use in the query the following:

SELECT TOP 10 .....(the rest of your query)