Limit the query output

  • Thread starter Thread starter Palia Weel
  • Start date Start date
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?
 
Look at the query properties while in design view and see if something
doesn't jump out at you.
 
Back
Top