Limit the query output

P

Palia Weel

I am a collage student which new in Access.

Currently I am doing an assignment. It is use the Access to store the
student data(personal and academic). I already built the table and the first
simple query, but I do not know how to limit the out put of the query.

The question is: show the top 5 student in academic result.

I can show all the academic result and sort it, but how to limit the output
to show only the top 5?
 
D

Duane Hookom

Look at the query properties while in design view and see if something
doesn't jump out at you.
 
Top